Snowflake - User Guide

In this article, you will understand step by step how to easily integrate with Snowflake

How to connect Snowflake integration?

Step 1:  Execute a query to create user, warehouse and role in Snowflake

• Log in to Snowflake as an account admin role.
• First, click on the account details located at the bottom left.
• Click on "copy account URL".

• Then, on the left menu, click on "Worksheets".
• Open a worksheet and run the following query that will create Scytale user.
• Please make sure you use the ACCOUNTADMIN role when running the query.
  

  -- Create warehouse and custom role CREATE OR REPLACE WAREHOUSE SCYTALE_WH;
  CREATE OR REPLACE WAREHOUSE SCYTALE_WH;
  CREATE OR REPLACE ROLE SCYTALE_ROLE;
  GRANT USAGE ON WAREHOUSE SCYTALE_WH TO ROLE SCYTALE_ROLE;
  -- This privilege is needed for some tests
  GRANT MONITOR SECURITY ON ACCOUNT TO ROLE SCYTALE_ROLE;
  
  -- Create user
  CREATE OR REPLACE USER SCYTALE_USER
  DEFAULT_WAREHOUSE = 'SCYTALE_WH'
  RSA_PUBLIC_KEY = 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA0luCbjHkCAY/ixN0OXKr 
  zDzseD7A9+ZoKn3G9aQAEy51JLA1IwgHu8nsD01tHl453hlFXbQJaDmLqyNBiOOU
  w4iIQMex7MuLyxrbaCvgRyzDd+Vw1+AA1kNnFhSri1wrQs0L6LpEVLUCbOML1Tfy
  tIUOBNdyLnI98iEoOoP47cG8RwKb6xqubzAr6FrQAjFVMHiEYJ+mc7pEyEC+c6TM
  yEx29wgOxbDtXys7tW4iA7v3P0aZBPx46bUqXBeR+8pvqP7Gzu/Mc/aycvod+S3n
  faRgh5NOAQOw6o4gNWhvH1ICtTDYvQdDs0Xe7sahBIQM9soOclphLRri/spbRNUy
  BQIDAQAB';

• Next, we will need to assign the SCYTALE_USER with the appropriate role.
• This step is crucial to ensure that the user has the necessary permissions.
• To do this, navigate to the "Admin" section on the left sidebar and select "Users & Roles".
• Locate the SCYTALE_USER and click on the edit option.
• In the "Default Role" field, select SCYTALE_ROLE and save the changes.

Step 2:  Log in to Scytale application to connect Snowflake

• Click on the "Integrations" menu screen on the left-hand side.
• Click on the Connect button under the Snowflake icon.
• Paste the Account URL you copied in step 1. 
• If you have executed the query in step 1 without making any changes to the user and warehouse alias, you can simply click on the connect button. 
• Connection Name - is used to differentiate between your connections.
  • For instance, if you manage multiple accounts or would like to connect multiple times to the integration. It's automatically titled (Connection 1,2,3 etc), but you can change it to a custom name to make it easier to identify.
    
    

✅ Click Done, Snowflake is connected.