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: