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 !
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