Q&A BY TAG 'CSV'
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
Error in Data source creation in ADLS 2 container
answered
15-07-2021 05:27:29 -0400
Hi, I am trying to establish a connection to read and write back a csv file ADLS 2.0 container. I am trying in custom wrapper so I configured my core-site.xml with my ADLS account with keys. When I try to test connection the connection is succes...
Answers:
2
CSV Create Base View Data sources Azure Data Lake Storage Gen2
Getting the Source Tables and columns for non-JDBC datasources
answered
08-06-2021 09:36:53 -0400
Hi Denodo Team, For the views created from JDBC datasource in denodo I am able to get the source tables by using the default procedure GET_SOURCE_TABLES(). But when I use the same procedure to get the underlying source table information for the datasou...
Answers:
1
source tables SAP CSV Denodo8 JDBC Data Sources source columns DataSource underlying tables
Files present in mount directory but not seen in ADLS container in azure portal UI
answered
24-12-2020 07:16:15 -0500
I am trying to export denodo view to ADLSv2. I am able to do the below things without any issues using Denodo Distributed File System Custom Wrapper connected to ADLSv2 container to read csv file from container created data source and base view i...
Answers:
1
Denodo on Azure BLOB azure blobl storage CSV Export Azure Data Lake Storage Gen2 azure
Sharepoint/OneDrive directory access to get CSV or Excel Files
answered
18-06-2020 06:58:01 -0400
Hello Denodo! We've been trying to get all the instructions in the following links to work with no success: https://community.denodo.com/answers/question/details?questionId=9060g000000Xf4oAAC&title=OneDrive+Connetion https://community.denodo...
Answers:
4
CSV Filename Column
answered
11-06-2020 06:44:58 -0400
I am curious if there is any way to include the filename or part of a filename for CSV files in the base view; something simlar to how the Excel wrapper can provide the sheetname as a column in the base view for an Excel data source. My use case scen...
Answers:
4
How to connect to a csv file placed in an HTTPpath?
answered
19-05-2020 04:38:02 -0400
Hi Team, I need to connect to a csv file placed in https path . Every day this path will get updated with a new csv file to which denodo needs to be connected and extraced the data. I tried to create using 'Delimited file' but the data doesnt show up ...
Answers:
1
Create a folder dinamically in Scheduler
answered
21-11-2019 16:03:22 -0500
I need to create a CSV exporter and I need that this exporter create a folder with the date. Is this possible? Example: /output/20191120/extract.csv /output/20191122/extract.csv ...
Answers:
1
Floating points not recognized correctly
answered
20-06-2019 08:47:15 -0400
Hi guys, I'm working with VDP 7.0 and I have this CSV file that amongst other airport-related data contains latitude and longitude information. Here's a sample row of the dataset so you don't have to download the whole file: 34,"Castlegar/West Koote...
Answers:
3
Merging CSV Files With Delta Files Dumped Into A SFTP Server Daily.
answered
10-10-2018 11:57:16 -0400
Hey, I am using VDP v7.0 with the latest upated tools and server. I have a use case where we have an SFTP server acting as a data source for us, which has CSVs dumped into it by another system which creates reports for us. For our initial load, we wil...
Answers:
1