How to load data into Snow flake from Amazon S3 using Diyotta?

How to load data into Snow flake from Amazon S3 using Diyotta?

Beginner Asked on July 17, 2019 in Spark Process Platform.
Add Comment
1 Answer(s)

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.

Expert Answered on July 17, 2019.
Add Comment

Your Answer

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