Snowflake Data Unloading Working Session | CSV, JSON, Parquet Data Export Technique
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: / learn_dataengineering
✏ Medium Blog: / data-engineering-simplified
✏ Exclusive Snowflake Facebook Group: / 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.