DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
Status
  1. Overview
    • Snowflake Horizon Catalog
      • Applications and tools for connecting to Snowflake
      • Virtual warehouses
      • Databases, Tables, & Views
      • Data Types
        • Data Loading
        • Dynamic Tables
        • Streams and Tasks
        • Data Unloading
        • Migration Tools
        • Queries
        • Listings
        • Collaboration
        • Snowflake AI & ML
        • Alerts & Notifications
        • Security
        • Data Governance
        • Privacy
        • Organizations & Accounts
        • Business continuity & data recovery
        • Performance Optimization
        • Cost & Billing

        Databases, Tables & Views¶

        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.

        Next Topics:

        • Understanding Snowflake Table Structures
        • Working with Temporary and Transient Tables
        • Working with external tables
        • Search Optimization Service
        • Overview of Views
        • Working with Secure Views
        • Working with Materialized Views
        • Table Design Considerations
        • Cloning considerations
        • Data storage considerations

        Was this page helpful?

        Visit Snowflake
        Join the conversation
        Develop with Snowflake
        Share your feedback
        Read the latest on our blog
        Get your own certification
        Privacy NoticeSite Terms© 2025 Snowflake, Inc. All Rights Reserved.
        1. Data Definition Language (DDL) commands
        Language: English
        • English
        • Français
        • Deutsch
        • 日本語
        • 한국어
        • Português