Navigating an Existing Database Structure
At Snowy Peak, you've just been handed access to a Snowflake account with no documentation and told to figure out what's there. This is a common real-world situation: the data exists, but no one left you a guide.
A database starting with COURSE_ is already set up with three schemas. The MARKETING schema contains two base tables.
Use SQL to explore the structure.
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