You can translate the question and the replies:

Multiple CSV files in AWS S3 folder location

Trying to figure out the logic to put in the path or the pattern field to create a base view that will utilize ALL CSV files in a particular S3 bucket folder location. DFSDelimitedTextFileWrapper is the wrapper being used currently. Is there something other than the location and .csv? that needs to be defined? *
user
22-09-2022 10:54:20 -0400

4 Answers

Hi, There is a Denodo documentation available for this topic in detail from here. [Denodo Distributed File System Custom Wrapper - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Distributed%20File%20System%20Custom%20Wrapper%20-%20User%20Manual) You can refer to the (H)DFSDelimitedTextFileWrapper section of the document for more detail on other attributes and its descriptions such as Delete after reading, Separator, etc. I also had tried with creating a CSV type data source in Denodo to multiple csv files on AWS S3 directly as well and one of demo can be found from youtube at below URL if you are interested. https://www.youtube.com/watch?v=iAnO6uIXt2M Hope this helps.
Denodo Team
23-09-2022 03:38:58 -0400
We are in Design Studio 8.0 so I do not see an option for S3 in the Data route option. Can you provide information on how to populate the file pattern field or other configuration for version 8.0?
user
23-09-2022 07:58:08 -0400
Actually, perhaps you can explain why S3 is not an option for us in the data route dropdown? is this only available for a specific relaese of 8.0?
user
23-09-2022 08:03:37 -0400
Hi, The S3 route option is supported from the Denodo v8.0 update 20220815 so you can update your product to have this available in the dropdown list. And all the previous versions and Denodo Platform v8.0 also includes a custom wrapper “Denodo Distributed File System Custom Wrapper” which is available from the Denodo support site using which you can still access csv files in S3 by referring below links. [How to integrate Amazon S3 with Denodo Distributed File System Custom Wrapper](https://community.denodo.com/kb/en/view/document/How%20to%20integrate%20Amazon%20S3%20with%20Denodo%20Distributed%20File%20System%20Custom%20Wrapper) And a video clip is again available from below URL as well [How to connect to AWS S3 from Denodo Platform](https://community.denodo.com/videos/details/Cloud/Denodo%207.0/How%20to%20connect%20to%20AWS%20S3%20from%20Denodo%20Platform) Hope this helps.
Denodo Team
26-09-2022 01:17:57 -0400
You must sign in to add an answer. If you do not have an account, you can register here