20 October 2018 · dan-irving ·       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


posted on 20 October 2018

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too