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 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';

 

 

❗If you come across this error while executing the query, it indicates that you are not currently in the correct role.


  • 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.