COF-C03 - Data Loading, Unloading, and Connectivity - Section 3.3
Unload data from Snowflake with COPY INTO location, choosing file format, compression, and single or multiple output files.
Unload query results to a stage with COPY INTO location: select the output file format and compression, choose between one file and many with the SINGLE and MAX_FILE_SIZE options, and retrieve files from an internal stage with GET. Recognise the default formats and how PARTITION BY can organise unloaded files.
data unloadingCOPY INTO locationSINGLE and MAX_FILE_SIZEGET commandfile compression
More in this domain
Back to all Data Loading, Unloading, and Connectivity objectives, or the COF-C03 cert hub.
Examworthy is not affiliated with or endorsed by Snowflake. Original, blueprint-aligned practice material only.