Skip to content

Before installing

This script creates a dedicated warehouse and an owner role, then grants that role what it needs to install WIRE and own it. Run it as ACCOUNTADMIN.

USE ROLE accountadmin;

-- Dedicated warehouse
CREATE WAREHOUSE IF NOT EXISTS wire_xs_wh
  WAREHOUSE_SIZE = XSMALL
  COMMENT = 'Used for the WIRE Native Application';

-- Role to own the application
CREATE ROLE IF NOT EXISTS wire_sysadmin
  COMMENT = 'System Administrator for WIRE Native App';

-- Install the app and own it
GRANT CREATE APPLICATION ON ACCOUNT TO ROLE wire_sysadmin;

-- Access the listing WIRE is shared through
GRANT IMPORT SHARE    ON ACCOUNT TO ROLE wire_sysadmin;
GRANT CREATE DATABASE ON ACCOUNT TO ROLE wire_sysadmin;

-- Compute for install and agent execution
GRANT USAGE, OPERATE ON WAREHOUSE wire_xs_wh TO ROLE wire_sysadmin;

GRANT ROLE wire_sysadmin TO ROLE sysadmin;   -- keep the role hierarchy intact
GRANT ROLE wire_sysadmin TO USER <user>;

Replace <user> with the user who will install the app.

Next, install WIRE from Marketplace as wire_sysadmin.