Uploaded November 2023 | Updated September 2026, 1 hour ago
Snowflake provides different approach to unload data from a table or from a query. To export data from Snowflake tables or from a custom query, in different file format need a copy command along with file format object. This hands on video will demonstrates the different approaches to export or unload data into named and un-nammed stage and role of different options in the copy command along with file format option.
This is complete hands on guide and through this working session, you would get a deeper knowledge of table and query data unloading technique.
🚀🚀 How To Connect
✏ Instagram: instagram.com/learn_dataengineering
✏ Medium Blog: medium.com/@data-engineering-simplified
✏ Exclusive Snowflake Facebook Group: facebook.com/groups/627874916138090
🚀🚀 Video Chapters Time Stamp
➥ 00:00 Introduction
➥ 02:41 welcome note
➥ 03:57 two variants of copy command
➥ 06:27 review data domain
➥ 07:35 unload table data into CSV format
➥ 12:31 download data to local machine
➥ 13:43 unload table data into CSV/GZip format
➥ 16:08 unload table data into TSV format
➥ 17:26 unload data into user/table stage
➥ 19:40 overwrite file unload option
➥ 21:18 how to limit file size
➥ 23:55 unload data into a single file
➥ 26:25 unload data with detailed output
➥ 27:17 include query id in unload data file
➥ 28:25 unload data with header
➥ 29:30 unload query data
➥ 30:52 unload data into partitioned files
➥ 33:10 unload data into parquet format
➥ 34:53 unload data into JSON format
➥ 36:41 unsupported file format while unloading data (ORC, Avro, xml)
➥ 37:48 summary
➥ 38:40 disclaimer
#snowflaketutorial
#snowflakecomputing
#snowflakedatawrehouse
#snowflake
#dataengineering
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.
Snowflake provides different approach to unload data from a table or from a query. To export data from Snowflake tables or from a custom query, in different file format need a copy command along with file format object. This hands on video will demonstrates the different approaches to export or unload data into named and un-nammed stage and role of different options in the copy command along with file format option.
This is complete hands on guide and through this working session, you would get a deeper knowledge of table and query data unloading technique.
🚀🚀 How To Connect
✏ Instagram: instagram.com/learn_dataengineering
✏ Medium Blog: medium.com/@data-engineering-simplified
✏ Exclusive Snowflake Facebook Group: facebook.com/groups/627874916138090
🚀🚀 Video Chapters Time Stamp
➥ 00:00 Introduction
➥ 02:41 welcome note
➥ 03:57 two variants of copy command
➥ 06:27 review data domain
➥ 07:35 unload table data into CSV format
➥ 12:31 download data to local machine
➥ 13:43 unload table data into CSV/GZip format
➥ 16:08 unload table data into TSV format
➥ 17:26 unload data into user/table stage
➥ 19:40 overwrite file unload option
➥ 21:18 how to limit file size
➥ 23:55 unload data into a single file
➥ 26:25 unload data with detailed output
➥ 27:17 include query id in unload data file
➥ 28:25 unload data with header
➥ 29:30 unload query data
➥ 30:52 unload data into partitioned files
➥ 33:10 unload data into parquet format
➥ 34:53 unload data into JSON format
➥ 36:41 unsupported file format while unloading data (ORC, Avro, xml)
➥ 37:48 summary
➥ 38:40 disclaimer
#snowflaketutorial
#snowflakecomputing
#snowflakedatawrehouse
#snowflake
#dataengineering
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.
