This video explains how to scan the Snowflake Resource in Cloud Data Governance and Catalog (CDGC).

HOW TO GENERATE PUBLIC/PRIVATE KEY PAIR

Generating private key
To generate an unencrypted version, use the following command:

openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt

To generate an encrypted version, use the following command (which omits “-nocrypt”):

openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8

Generating public key
Assuming that the private key created in the previous step is contained in the file named "rsa_key.p8", use the following command to generate a public key:

openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub


ASSIGN PUBLIC KEY TO USER

Use the following command on the Snowflake console to assign a public key to the user. Users with a SecurityAdmin role or higher can ALTER user
alter user "user" set rsa_public_key='content of the public key created in the previous step after removing header/footer lines’;


CREATE INTEGRATION SECURITY

create or replace security integration "Integration_Security_Name"
type=oauth
enabled=true
oauth_client=CUSTOM
oauth_client_type='CONFIDENTIAL'
oauth_redirect_uri='[ Ссылка ]'
oauth_issue_refresh_tokens=true
oauth_refresh_token_validity=86400;

GET CLIENT SECRET USING BELOW QUERY
select SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('Integration_Security_Name’);

Reference
Catalog Source Configuration – Snowflake - [ Ссылка ]


Product - Cloud Data Governance and Catalog (CDGC)
Expertise: Expert, Beginner
User type: Administrator, Developer
Category: Configuration, Product Feature
Project Phase: Onboard, Configure
Problem Type: Configuration

свернуть