Step 5. Clean Up

Congratulations, you have successfully completed the tutorial.

Tutorial Key Points

  • Partitioning the event data in your S3 bucket using logical, granular paths allows you to copy a subset of the partitioned data into Snowflake with a single command.

  • Snowflake’s column:key notation, similar to the familiar SQL table.column notation, allows you to effectively query a column within the column (i.e., a sub-column), which is dynamically derived based on the schema definition embedded in the JSON data.

  • The FLATTEN function allows you to parse JSON data into separate columns.

  • Several options are available to update table data based on comparisons with staged data files.

Tutorial Clean Up (Optional)

Execute the following DROP <object> commands to return your system to its state before you began the tutorial:

DROP DATABASE IF EXISTS mydatabase;
DROP WAREHOUSE IF EXISTS mywarehouse;
Copy

Dropping the database automatically removes all child database objects such as tables.

Language: English