Create a virtual warehouse to run Observe for Snowflake

You can create a virtual warehouse in Snowflake using the UI or the consnole.

Create a virtual warehouse from the UI

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

  1. Log into your Snowflake instance in Snowsight console.
  2. Change to the SYSADMIN role or whatever role you use to create virtual warehouses.
  3. Navigate to Admin\Warehouses.
  4. Click + Warehouse.
  5. Create the warehouse:
    1. Choose X-Small in Size.
    2. Choose Standard in Type.
    3. Give the warehouse a name, such as O4S_WH.
    4. Check Auto-resume.
    5. Check Auto-suspend.
    6. Specify 1 minute for the inactivity period.
  6. Click Create Warehouse.

Create a virtual warehouse from the Console

Perform the following tasks:

  1. Log into your Snowflake instance in Snowsight console
  2. Navigate to Project\Worksheets.
  3. Create new Worksheet and name is o4s scripted install. This worksheet will continue to be used throughout the exercise so keep it open.
  4. Run the following commands:
--------------------------------------------------------------------------------
-- [ 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;