Snowflake

How can I connect Snowflake to Relay.app?

• In a SQL file, create a new security integration by running the following

CREATE OR REPLACE SECURITY INTEGRATION relay_app_integration
  TYPE = OAUTH
  ENABLED = TRUE
  OAUTH_CLIENT = CUSTOM
  OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
  OAUTH_REDIRECT_URI = 'https://run.relay.app/connect/callback/snowflake'
  OAUTH_ISSUE_REFRESH_TOKENS = TRUE
  OAUTH_REFRESH_TOKEN_VALIDITY = 86400;

• Run the following to reveal the Oauth secrets which Relay.app will need to connect

SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('RELAY_APP_INTEGRATION');

Finally, retrieve the instance URL from the 'accounts' settings page:

• Finally, enter these pieces of information into the Relay.app connection dialog and click connect