Ready to Snoptimize your account?

Copy the code below into your Snowflake dashboard to install Snoptimizer

Install Snoptimizer

/* --CUSTOMER EXECUTED Snoptimizer Installation - Installation Begins -- */

/*
SNOPTIMIZER CONFIGURATION SECTION.  
THIS MUST BE CORRECTLY FILLED OUT OR IT WILL FAIL
Contact Snoptimizer Support if you run into any issues.
*/

/*****  CUSTOMER CONFIGURATION BEGIN **********************
***********************************************************
*/
USE ROLE ACCOUNTADMIN;
// The role used above needs to match the next line so the context stays set.
SET AA_INSTALLATION_ROLE='ACCOUNTADMIN';
SET SECURITY_INSTALLATION_ROLE='SECURITYADMIN';
SET ORGADMIN_ROLE='ORGADMIN';
/*  If you need to run the installation with other roles then
they must be tested by the Snoptimizer Team to verify it has the required GRANTS.*/

/*****  CUSTOMER CONFIGURATION END ************************
***********************************************************
*/

/* --Automated Snoptimizer Installation -- DO NOT CHANGE ANYTHING BELOW HERE */
USE ROLE IDENTIFIER($AA_INSTALLATION_ROLE);
SELECT 'SECURITY_ROLE=' || $SECURITY_INSTALLATION_ROLE;
/*  INSTALLATION FOR AWS EAST */
SET PROVIDER_ACCT='ITS.SNOPT_';  //  vnb81538
SET ENV='PROD';
ALTER SESSION SET QUERY_TAG='SNOPTIMIZER_INSTALL';
SET SNOPT_ROLE='EXT_SNOPTIMIZER_ROLE';
SET SHARE_FROM_PROVIDER=CONCAT($PROVIDER_ACCT,'.ITS_SERVICES_SHARE_',$ENV);
SET SHARE_NAME_BASE=CONCAT('ITS_SERVICES_SHARE_', $ENV);