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

SnowSQL (CLI Client)

Est. Time

30-40 minutes

Est. Credits

< 1

Before You Begin:

Steps: