Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Load -part0 format to csv

Hi,

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

Matillion Agent  

Damian Chan —

Hello Sarath,

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:

https://snowflakesupport.matillion.com/customer/en/portal/articles/2167231-s3-unload-component?b_id=16164

Best Regards,
Damian

Post Your Community Answer

To add an answer please login