Get startedGet started for free

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.

⚠️ Can't select a database, or getting a "table not found" error?

Use the table's full path in your 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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise