Step 5. 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.
column.elementnotation, 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 LATERAL 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;
Dropping the database automatically removes all child database objects such as tables.
Before you drop the warehouse, consider whether you are going to complete any of the other tutorials, which all require a warehouse. You might be able to save some time and credits by reusing this warehouse for the other tutorials.