Tutorial: JSON Basics¶
In this tutorial, you do the following:
Upload sample JSON data from a public S3 bucket into a column of the
variant
type in a Snowflake table.Test simple queries for JSON data in the table.
Explore the FLATTEN function to flatten JSON data into a relational representation and save it in another table.
Explore ways to ensure uniqueness as you insert rows in the flattened version of the data.
- Interface
- Est. Time
30-40 minutes
- Est. Credits
< 1
Before You Begin:
Steps: