How to register your own Snowflake OAuth app

Run the following SQL in your Snowflake worksheet as an ACCOUNTADMIN (or a role with the CREATE INTEGRATION privilege):

CREATE SECURITY INTEGRATION <integration_name>
    TYPE = OAUTH
    ENABLED = TRUE
    OAUTH_CLIENT = CUSTOM
    OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
    OAUTH_REDIRECT_URI = 'https://api.tenklo.dev/oauth/callback'
    OAUTH_ISSUE_REFRESH_TOKENS = TRUE
    OAUTH_REFRESH_TOKEN_VALIDITY = 86400;

Replace <integration_name> with a name for your integration.

Run these queries to retrieve your credentials:

SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('<integration_name>');

Note your OAuth client ID and OAuth client secret.

Assign the correct role/scope to the OAuth integration so the token has the right permissions. See Snowflake OAuth scopes for details.

Follow the Quickstart.