20 Oct 18 · dan-irving · #snowflake ·   Bookmark   ×

Difference between Database vs Schema in Snowflake

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.

So, If you use the same snowflake account, then

  • Each database will be an environment
  • Each Schema will hold its own group of STAGE, DATA or VIEWS

To choose the correct schema / Database use the "USE SCHEMA" or "USE DATABASE" commands before we can actually submit the query

dan-irving

posted on 20 Oct 18

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied