Database, Schema, & Share DDL

Related Topics

• Introduction to Data Sharing
• Object Name Resolution
• Table, View & Sequence DDL

Databases and schemas are used to organize data stored in Snowflake:

• A database is a logical grouping of schemas. Each database belongs to a single Snowflake account.
• A schema is a logical grouping of database objects (tables, views, etc.). Each schema belongs to a single database.

Together, a database and schema comprise a namespace in Snowflake. When performing any operations on database objects in Snowflake, the namespace is inferred from the current database and schema in use for the session. If a database and schema are not in use for the session, the namespace must be explicitly specified when performing any operations on the objects.

In addition to databases and schemas, Snowflake provides DDL for creating and managing shares. A share specifies a set of objects in a database to share with one or more accounts.

Database Management

• CREATE DATABASE
• CREATE DATABASE ... CLONE
• ALTER DATABASE
• DROP DATABASE
• UNDROP DATABASE
• USE DATABASE
• SHOW DATABASES

Schema Management

• CREATE SCHEMA
• CREATE SCHEMA ... CLONE
• ALTER SCHEMA
• DROP SCHEMA
• UNDROP SCHEMA
• USE SCHEMA
• SHOW SCHEMAS

Share Management

New Feature — Available On Request

Data Sharing is not enabled by default. To request this feature, please contact Snowflake Support.

• CREATE SHARE
• ALTER SHARE
• DROP SHARE
• SHOW SHARES
• DESC SHARE