on 01-21-2021 4:50 PM
Hi Experts,
we have a batch of CSV files in local system and would need to auto load the csv data to DWC system table.
can we do this via custom sql query and load into DWC ? or please let me know the ideal approach on how to automate the process of importing csv to datawarehouse cloud.
At DWC Roadmap a FTP based connection is planned for Q3 2021, and this option will allow to import CSV data with Data Flows.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
At the moment it is not possible to do this automatically. There is no "CSV" connection type that allows remote access or use it in Data Flow.
I have not tested it, but I think that an option, although complex, would be to use in DWC a JDBC connection, and to configure a JDBC driver to access CSV (there are paid ones and some open source). This would allow viewing the files as remote tables.
Other options are possible, but they involve using third party systems (HANA, Azure, etc) and access through these systems.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.