RE: How to unload data from Snowflake using Diyotta?

How to unload data from Snowflake using Diyotta?

Add Comment
1 Answers

Diyotta can unload Snowflake data by using two techniques.

  1. Snowflake Bulk Export
Step 1: Use the COPY INTO <location> command to copy the data from the Snowflake database table into one file in a Snowflake or external stage.
Step 2: Download the file from the stage:

  • From a Snowflake stage, use the GET command to download the data file(s).
  • From S3, use the interfaces/tools provided by Amazon S3 to get the data file(s).
  • From Azure, use the interfaces/tools provided by Microsoft Azure to get the data file(s).
  1. JDBC

Preparing “SELECT” Query and triggering it on selected database by connect to snowflake using JDBC. Once get result set from database, read result set and write into stage file by taking the extract input given by user.

 

RE: How to unload data from Snowflake using Diyotta?

Expert Answered on July 16, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.