Databases and schemas in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new database named 'sales_db'.

Snowflake

CREATE DATABASE [1];

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

ADROP

BCREATE

CUSE

Dsales_db

Attempts:

3 left

💡 Hint

Common Mistakes

Using keywords like CREATE or USE instead of the database name.

Forgetting to specify the database name.

The CREATE DATABASE command followed by the database name creates a new database.

2fill in blank

medium

Complete the code to switch to the 'sales_db' database.

Snowflake

USE [1];

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

ACREATE

BDROP

Csales_db

DSCHEMA

Attempts:

3 left

💡 Hint

Common Mistakes

Using CREATE instead of USE.

Using SCHEMA instead of the database name.

The USE command followed by the database name switches the current context to that database.

3fill in blank

hard

Fix the error in the code to create a schema named 'marketing' inside the 'sales_db' database.

Snowflake

CREATE SCHEMA [1].marketing;

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

Asales_db

BCREATE

CUSE

DDROP

Attempts:

3 left

💡 Hint

Common Mistakes

Using keywords like CREATE or USE instead of the database name.

Omitting the database name before the schema.

To create a schema inside a database, prefix the schema name with the database name separated by a dot.

4fill in blank

hard

Fill both blanks to switch to the 'marketing' schema inside the 'sales_db' database.

Snowflake

USE [1].[2];

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

Asales_db

Bmarketing

Cfinance

DCREATE

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the order of database and schema.

Using CREATE instead of schema name.

The USE command can switch to a specific schema by specifying database.schema.

5fill in blank

hard

Fill all three blanks to create a table named 'customers' with columns 'id' (integer) and 'name' (string) inside the 'marketing' schema of 'sales_db'.

Snowflake

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

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

Asales_db

Bmarketing

Ccustomers

DCREATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using CREATE as a name instead of database, schema, or table.

Mixing the order of database, schema, and table.

To create a table inside a schema and database, specify database.schema.table.