Databases, Tables and Views - Overview¶
All data in Snowflake is maintained in databases. Each database consists of one or more schemas, which are logical groupings of database objects, such as tables and views. Snowflake does not place any hard limits on the number of databases, schemas (within a database), or objects (within a schema) you can create.
Use the following pages to learn about tables and table types, views, design considerations and other related content.
- Understanding Snowflake Table Structures
Introduction to micro-partitions and data clustering, two of the principal concepts utilized in Snowflake physical table structures.
- Temporary and Transient Tables
Snowflake supports creating temporary tables for storing non-permanent, transitory data such as ETL data, session-specific or other short lived data.
- External Tables
Snowflake supports the concept of an external table. With external tables data is stored in files in an external stage.
A view allows the result of a query to be accessed as if it were a table. Views serve a variety of purposes, including combining, segregating, and protecting data.
- Secure Views
Snowflake supports the concept of a secure view. Secure views are specifically designed for data privacy. For example to limit access to sensitive data that should not be exposed to all users of the underlying table(s).
- Materialized Views
Materialized views are views precomputed from data derived from a query specification and stored for later use. Querying a materialized view is faster than executing a query against the base table of the view because the data is pre-computed.
- Table Design Best Practices
Best practices, general guidelines, and important considerations when designing and managing tables.
- Cloning Best Practices
Best practices, general guidelines, and important considerations when cloning objects in Snowflake, particularly databases, schemas, and permanent tables.
- Data Storage Considerations
Best practices and guidelines for controlling data storage costs associated with Continuous Data Protection (CDP), particularly for tables.