05 January 2019        Add to Favorites   Report

Setup the environment in Snowflake


We will create the virtual warehouse, database, and the schema. The SQL commands used in the lesson are given below. Just click on the code snippet once to copy to clipboard.

Creating a Virtual Warehouse:

CREATE WAREHOUSE TRAINING_WH
WITH
WAREHOUSE_SIZE = XSMALL
AUTO_SUSPEND = 60
AUTO_RESUME = TRUE
INITIALLY_SUSPENDED = TRUE
STATEMENT_QUEUED_TIMEOUT_IN_SECONDS = 300
STATEMENT_TIMEOUT_IN_SECONDS = 600;

Creating a Database (Remember to substitute your username):

CREATE DATABASE SALES_{USERNAME}_DB
DATA_RETENTION_TIME_IN_DAYS = 0
COMMENT = 'Ecommerce sales info';

Creating multiple Schemas:

create schema Sales_Data;
create schema Sales_Views;
create schema Sales_Stage;

Setting Context:

USE WAREHOUSE TRAINING_WH;
USE DATABASE SALES_{USERNAME}_DB;
USE SCHEMA Sales_Data;

Finding the context:

select CURRENT_DATABASE(), CURRENT_SCHEMA(), CURRENT_WAREHOUSE();

📙 Course Index
◀ Prev: Tour the snowflake user interface
▶ Next:


Read great educational content like this and a lot more ! Create my free account now 🎁

Copied