D3.4 - OUTLINE HOW DATA CAN BE UNLOADED FROM SNOWFLAKE TO EITHER LOCAL STORAGE OR CLOUD STORAGE

Question 1

Define Supported Formats

Answer 1

• Structured: Delimited (CSV,TSV, etc)

- Semi-Structured: JSON, Parquet, ORC. AVRO, XML

Question 2

Commands that help when unloading data

Answer 2

COPY INTO command to copy the data from Snowflake database table into one or more files in a Snowflake or external stage

Question 3

Define Best Practice when Unloading Data

Answer 3

• Bulk Unloading is the same as loading except reverse:
• Step 1. COPY INTO command to copy the data from Snowflake database table into one or more files in a Snowflake or external stage
• Step 2: download the file from the stage
• From a snowflake stage, use the GET command, or from a Cloud provider, use their tools