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