Why object hierarchy organizes data in Snowflake - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all columns from the table in the correct schema.

Snowflake

SELECT * FROM [1].my_table;

Drag options to blanks, or click blank then click option'

Atable

Bdatabase

Ccolumn

Dschema

Attempts:

3 left

💡 Hint

Common Mistakes

Using database name instead of schema

Using table name instead of schema

The schema organizes tables inside a database, so you must specify the schema to access the table.

2fill in blank

medium

Complete the code to create a new schema inside a database.

Snowflake

CREATE SCHEMA [1];

Drag options to blanks, or click blank then click option'

Amy_database

Bmy_schema

Cmy_table

Dmy_column

Attempts:

3 left

💡 Hint

Common Mistakes

Using database name instead of schema name

Using table name instead of schema name

You create a schema by naming it directly; schemas organize tables inside databases.

3fill in blank

hard

Fix the error in the code to correctly reference a table in a database and schema.

Snowflake

SELECT * FROM [1].my_schema.my_table;

Drag options to blanks, or click blank then click option'

Amy_table

Bmy_column

Cmy_database

Dmy_schema

Attempts:

3 left

💡 Hint

Common Mistakes

Using schema name as the first part

Using table name as the first part

The correct order is database.schema.table. The first part must be the database name.

4fill in blank

hard

Fill both blanks to create a fully qualified table name in Snowflake.

Snowflake

SELECT * FROM [1].[2].sales_data;

Drag options to blanks, or click blank then click option'

Amy_database

Bmy_schema

Csales_data

Dcustomer_data

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping database and schema names

Using table names in blanks

The full path to a table is database.schema.table. Here, sales_data is the table, so blanks are database and schema.

5fill in blank

hard

Fill all three blanks to create a new table in the correct database and schema.

Snowflake

CREATE TABLE [1].[2].[3] (id INT, name STRING);

Drag options to blanks, or click blank then click option'

Aanalytics_db

Bpublic

Ccustomers

Dorders

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up schema and table names

Using incorrect database name

To create a table, specify database.schema.table. Here, analytics_db is the database, public is the schema, and customers is the table.