19 October 2018 · Mike-Barn ·       Add to Favorites   Report

How to switch to a Warehouse, Database, Schema using SQL query in Snowflake

The first step in Snowflake is to choose your Virtual Warehouse, Correct Database and schema. Once you have done that you can start executing your favorite queries. The warehouse must be running before queries and other DML statements can be executed in the session (If you have given AUTO_RESUME=TRUE, it will start automatically once you fire the query)

Example

USE WAREHOUSE MARKETING_TEAM_WH;
USE DATABASE SALES_WH_DB;
USE SCHEMA POWER_USER_VIEWS;

You can also verify if you are in the correct schema, using the below command:

select current_warehouse(), current_database(), current_schema();

Output:

+---------------------+--------------------+------------------+
| CURRENT_WAREHOUSE() | CURRENT_DATABASE() | CURRENT_SCHEMA() |
|---------------------+--------------------+------------------|
| MARKETING_TEAM_WH | SALES_WH_DB | POWER_USER_VIEWS |
+---------------------+--------------------+------------------+

Related Error:

Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name.

If you see this error, you will have to choose the correct database name as mentioned in this article.


Mike-Barn

posted on 19 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

Copied