Databases and schemas in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a database in Snowflake?

A database in Snowflake is a container that holds schemas, which in turn contain tables and other database objects. It organizes data logically for easy management.

beginner

What is a schema in Snowflake?

A schema is a way to group database objects like tables and views inside a database. It helps organize and separate data within the database.

beginner

How do databases and schemas relate in Snowflake?

A database contains one or more schemas. Schemas organize the data objects inside the database, like folders inside a filing cabinet.

intermediate

Why use multiple schemas in a Snowflake database?

Using multiple schemas helps separate data by project, team, or purpose. It improves organization, security, and access control.

beginner

How do you create a new schema in Snowflake?

You use the SQL command: CREATE SCHEMA schema_name; inside the desired database to create a new schema.

In Snowflake, what does a schema contain?

A Users

B Databases

C Warehouses

D Tables and views

Schemas contain tables, views, and other database objects. Databases contain schemas.

Which command creates a new database in Snowflake?

A CREATE DATABASE db_name;

B CREATE SCHEMA db_name;

C CREATE WAREHOUSE db_name;

D CREATE TABLE db_name;

The command CREATE DATABASE creates a new database.

What is the main purpose of using schemas in a database?

A To organize and separate data objects

B To store user passwords

C To run queries faster

D To create backups

Schemas help organize and separate tables and other objects inside a database.

Which of these is true about Snowflake databases?

A They contain warehouses

B They contain users

C They contain schemas

D They contain roles

Databases contain schemas. Warehouses, users, and roles are separate Snowflake objects.

How do you refer to a table inside a schema and database in Snowflake?

A schema.database.table

B database.schema.table

C table.schema.database

D schema.table.database

The correct order is database.schema.table to fully qualify a table.

Explain the relationship between databases and schemas in Snowflake and why this structure is useful.

Think of databases as big folders and schemas as smaller folders inside.

Describe how you would create and use multiple schemas in a Snowflake database for a team project.

Consider how dividing work helps keep things clear and secure.