Snowflake Cortex AI Connector Guide

Back Next

Prerequisites

You need the client ID and client secret to configure the Snowflake Cortex AI Connector using OAuth 2.0 authentication.

To retrieve the client ID and client secret, perform the following steps:

Click

Add

SQL File

as shown in the following image:

To alter the user and set the sysadmin as the default user, run the following query :

alter user <username> set default_role = sysadmin;

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

The integration name must be in capital letters.

For more information, see the Snowflake documentation.

To grant all the permissions to sysadmin, run the following query:

GRANT ALL ON INTEGRATION <integration_name> to sysadmin;

To 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:

To retrieve the client credentials of the security integration, run the following query:

select system$show_oauth_client_secrets('<integration_name>');

Snowflake Cortex AI connections

Download Guide

Watch

Comments

Cloud Application Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Snowflake Cortex AI Connector Guide

Snowflake Cortex AI Connector Guide

Prerequisites

Prerequisites