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.