20 October 2018        Add to Favorites   Report

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

Read great educational content like this and a lot more ! Create my free account now 🎁