Coffee77
Honored Contributor II

Create indeed a different catalog for environment (DEV, QA, Staging, Prod), new schema/databases inside and then tables, views, volumes or functions following the three names convention <catalog_name>.<schema_name>.<table_name>. Remove, of course, the schema name from the tables or any other child data object. You can query system tables to list all objects per schema and catalog if needed.

 


Lifelong Solution Architect Learner | Coffee & Data