Setting up Snowy Peak's database structure
Snowy Peak's database is already in production with several operational schemas. The analytics team has requested a dedicated schema for their reporting work.
You need to create the ANALYTICS schema, set your working context, and use INFORMATION_SCHEMA to confirm the full structure is in place.
Use the table's full path in your ⚠️ Can't select a database, or getting a "table not found" error?
FROM clause. Get it from the left panel: Databases tab → expand your COURSE_… database → select the table → Copy name.
This exercise is part of the course
Snowflake Architecture
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise