Tutorials: Work with semi-structured data¶

The following tutorials provide examples and step-by-step instructions you can follow as you learn to work with semi-structured data in Snowflake:

Note

These tutorials show you how to load data into a table by using the COPY INTO <table> command. For information about other options for loading data, see Overview of data loading.

Learn the basics of using JSON with Snowflake: Describes the basics of using JSON with Snowflake.
Load JSON data into a relational table: Uses a COPY INTO <table> command with a SELECT statement to load individual elements in a staged JSON file into a table.
Load and unload Parquet data: Describes how you can upload Parquet data by transforming elements of a staged Parquet file directly into table columns using the COPY INTO <table> command. The tutorial also describes how you can use the COPY INTO <location> command to unload table data into a Parquet file.