Snowflake snippets
Query warehouse, database and schema
To query the current warehouse, database, and schema name you can just use the following snippet:
select current_warehouse(), current_database(), current_schema();
Nicola Simboli Senior Analytics Engineer
15+ years across SaaS, enterprise and consulting. Focused on scalable data platforms, metric reliability and analytics systems that teams actually use.