- Connecting to Snowflake
- Loading Data in Snowflake
- Using Snowflake
- Sharing Data in Snowflake
- Managing Your Snowflake Account
- Managing Security in Snowflake
- General Reference
- SQL Command Reference
- Summary of Commands
- Commands (Alphabetical)
- DDL Commands (by Category)
- DML Commands (by Category)
- Query Constructs
- SQL Operator & Function Reference
Database, Schema, & Share DDL¶
Data Sharing is enabled, by default, for most accounts. If it is not enabled for your account, please contact Snowflake Support.
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.
Snowflake provides a full set of DDL commands for creating and managing databases and schemas.
In addition, Snowflake provides DDL for creating and managing shares. A share specifies a set of database objects (schemas, tables, and secure views) containing data you wish to share with other Snowflake accounts.
In this Topic: