Q1. I use database query transformation to load sql server table data in S3 staging , while loading in S3 bucket it is in -part0 file, it tried opening with 7zip and opened in excel ,column names are missing ..
Is it possible to load the table in CSV format in S3 Staging
Q2. I don't find staging bucket clean stage on/off properties in JDBC Incremental Load Component ... It is possible to load the sql server table in S3 staging bucket otherwise once tables loaded in snowflake after that how can i convert the snowflake table to CSV and load into S3 bucket ....
1 Community Answers
Damian Chan —
Unfortunately, that’s not possible. You wouldn’t be able to have the staging data as CSV whilst it’s loading into Snowflake.
The clean stage on/off feature is not available for that component.
Finally, you can export your data out from Snowflake into S3 in CSV format using the S3 Unload Component. More information is provided below: