A base repository containing scripts and example datasets for the Cortex Dataset Activity at Snowflake Summit 2026.
This activity walks participants through loading and analyzing datasets using Snowflake Cortex, Snowflake's suite of AI and ML features. This repo provides everything needed to set up, run, and reset the environment for the activity.
├── cleanup.sql # Resets the Snowflake environment between uses
└── example_dataset/
└── 311data.csv # Example dataset for the activity
- A Snowflake account with access to the
SNOWFLAKE_LEARNING_DBdatabase - Appropriate privileges to create and drop tables and semantic views
- Clone this repository or download the example CSV:
git clone https://github.com/your-org/summit26-cortex-dataset-activity.git
- Load the example dataset from
example_dataset/311data.csvinto your Snowflake environment. - Follow the activity instructions provided at the event.
To reset the Snowflake environment between uses (e.g., between groups of participants), run the cleanup script:
-- In a Snowflake worksheet, execute:
EXECUTE IMMEDIATE FROM @your_stage/cleanup.sql;Or paste the contents of cleanup.sql directly into a Snowflake worksheet and run it.
The script will:
- Drop all semantic views in
SNOWFLAKE_LEARNING_DB - Drop all tables in
SNOWFLAKE_LEARNING_DB - Print a confirmation message when complete
Note: The cleanup script targets
SNOWFLAKE_LEARNING_DB. Make sure this database exists and that you are using the correct role before running it.
This project is licensed under the terms found in the LICENSE file.