Q&A BY TAG 'AWS S3'

You must sign in to ask a question. If you do not have an account, you can register here

How to search for a range of dates based on a text value - Interpolation variable
answered 04-10-2021 11:47:56 -0400

I currently have a baseview that with an interpolation variable for a date value that can be used to dynamically target a specific CSV file on AWS S3 as the source. select * from hcc_dv.dv_ctigeneral_s3_gdw_backupdate where backupdate = '09-01-2021' ...

Answers: 6

Interpolation Variables AWS S3

Dynamic Path for Custom S3 Wrapper
answered 31-08-2021 09:05:29 -0400

I have a backup file that is time stamped like this each day: GDW_08-30-2021.csv The current path to reference this file in the custom wrapper via AWS S3... looks like this: /gdw_backup/GDW_08-30-2021.csv is there a way to embed a caclulated value ...

Answers: 2

Formula Dynamic CSV AWS S3 Distributed File System Custom Wrapper

Access to data sources on S3
answered 21-04-2021 23:41:07 -0400

Hi. Several days ago I started to test Denodo Standard 8.0 (free trial) for learning yours platform on AWS. And now when I try to connect S3 file system for my test cluster I have such problems (https://community.denodo.com/kb/view/document/How%20to%20...

Answers: 1

AWS S3

Denodo unable to fetch all the records for an entity which contains different Schemas file extensions for the parquet files from S3
answered 24-02-2021 06:15:56 -0500

Hello, I tried to create a base with file pattern (.) for the parquet file entity/table in s3 region. Then, when i excute the count query to fetch all the recodrs in the entity.I could able to get the below mentioned error. Finished with error: Error ...

Answers: 3

custom S3 HDFSCustomWrapper; S3 DENODO AWS S3 Create Base View

Store logs in csv format S3
answered 10-09-2020 04:03:05 -0400

Hello, I have set up the log4j.xml file to store the VDP-queries log to S3 location. I can see that the files stored are in an unreadable format. Can you please let me know if I can store them in csv format? I have followed the below link to set it up...

Answers: 1

AWS S3 query logs logging log4j2.xml

Issues connecting Amazon S3 bucket with Denodo VDP
answered 21-07-2020 18:06:42 -0400

Hi team, I'm trying to connect Denodo and retrieve CSV files from a S3 Bucket. I have followed all the steps provided in this article: https://community.denodo.com/kb/view/document/How%20to%20integrate%20Amazon%20S3%20with%20Denodo%20Distributed%20Fil...

Answers: 3

AWS S3

Denodo cache in AWS
answered 09-07-2020 00:30:30 -0400

What is the best database alternative to use in AWS as Denodo cache? (having S3 as main source to create "virtual datamarts").

Answers: 3

AWS S3

joining multiple base view error via custom wrapper parquet file in S3.
answered 08-07-2020 11:00:56 -0400

Hi Team, I am getting below error while creating the derived view from joining multiple base view. Accessing the AWS S3 bucket data source from custom wrapper parquet file in S3. [CUSTOM WRAPPER] [ERROR] Received exception with message 'Error accessi...

Answers: 3

S3 parquet file DENODO AWS S3 derived view custom wrapper

Denodo to S3 connection at a bucket level ( not an object level)
answered 11-05-2020 08:48:34 -0400

Hello Denodo Team, I have a need to connect from Denodo to a S3 bucket. The S3 bucket receives daily incremental files of a specific object ( same structure for all files ). For example, let us say that S3 bucket contains Campaign data. I will continue...

Answers: 3

S3 bucket AWS S3

getting HTTP error code 403 on creating base view
answered 15-04-2019 08:27:41 -0400

I'm trying to connect s3, following this Amazon S3 REST API section. my s3 is (dummy info below) bucket: denodo-test file:/denodo.txt (no folder) I have IAM account with full access to s3. I could get se file with awscli. on base view creation part,...

Answers: 3
Related to: How to integrate Amazon S3 with the Denodo Platform

AWS S3