Prerequisites

1. 1Log in to your Snowflake account using https://app.snowflake.com/<organization name>/<account name>/#/homepage.
2. 2Click Add > SQL File as shown in the following image:

3. 3To alter the user and set the sysadmin as the default user, run the following query :
alter user <username> set default_role = sysadmin;
4. 4To create the security integration, run the following query:
CREATE SECURITY INTEGRATION <integration_name>
TYPE = OAUTH
ENABLED = TRUE
OAUTH_CLIENT = CUSTOM
OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
OAUTH_REDIRECT_URI = '<https://<your POD>/oauthcallback>'
OAUTH_ISSUE_REFRESH_TOKENS = TRUE
OAUTH_REFRESH_TOKEN_VALIDITY = 86400
;
Note: The integration name must be in capital letters.
For more information, see the Snowflake documentation.
5. 5To grant all the permissions to sysadmin, run the following query:
GRANT ALL ON INTEGRATION <integration_name> to sysadmin;
6. 6To describe the security integration and retrieve the authorization URL and token request URL, run the following query:
DESCRIBE SECURITY INTEGRATION <integration_name>;
Copy the authorization URL and token request URL as shown in the following image:

7. 7To retrieve the client credentials of the security integration, run the following query:
select system$show_oauth_client_secrets('<integration_name>');