Create Virtual Warehouse to Run Observe for Snowflake¶

Create Virtual Warehouse to Run Observe for Snowflake - Via UI¶

Snowflake for Observe native application needs a virtual warehouse to run admin UI and (optionally) run the tasks.

Log into your Snowflake instance in Snowsight console
Change to the SYSADMIN role or whatever role you use to create virtual warehouses
Navigate to Admin\Warehouses
Click + Warehouse button
Create warehouse
- Choose X-Small in Size
- Choose Standard in Type
- We recommend you call it O4S_WH
- Check Auto-resume
- Check Auto-suspend
- Specify 1 minute for inactivity period
Click Create Warehouse

Observe For Snowflake - Create Virtual Warehouse

Create Virtual Warehouse to Run Observe for Snowflake - Via Console¶

Log into your Snowflake instance in Snowsight console
Navigate to Project\Worksheets
Create new Worksheet and name is o4s scripted install .
- This worksheet will continue to be used throughout the exercise so keep it open
Run:

--------------------------------------------------------------------------------
-- [ manual ]
-- Step 0: Provision warehouse to be used
--------------------------------------------------------------------------------
USE ROLE SYSADMIN;

CREATE WAREHOUSE IF NOT EXISTS O4S_WH;
ALTER WAREHOUSE SET WAREHOUSE_SIZE = XSMALL;
ALTER WAREHOUSE SET AUTO_SUSPEND = 60;
ALTER WAREHOUSE O4S_WH SUSPEND;