DOCUMENTATION
/
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  1. Overview
    • Snowflake Horizon Catalog
    • Applications and tools for connecting to Snowflake
    • Virtual warehouses
    • Databases, Tables, & Views
    • Data types
      • Data Integration
        1. Snowflake Openflow
        2. Apache Iceberg™
          1. Apache Iceberg™ Tables
          2. Snowflake Open Catalog
      • Data Engineering
        1. Data Loading
        2. Dynamic Tables
        3. Streams and Tasks
        4. dbt Projects on Snowflake
        5. Data Unloading
      • Migrations
      • 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
      • Introduction to 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 TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.
      1. Data Definition Language (DDL) commands
      Language: English
      • English
      • Français
      • Deutsch
      • 日本語
      • 한국어
      • Português