Learn how to authenticate your Snowflake user by generating and assigning a public RSA key using the Secrets API.

1. Generate an RSA public key using the Secrets

   Send a POST request to the following endpoint:

   
   POST {{hub-url}}/api/tenants/{{tenantID}}/adapters/{{adapterName}}/secrets
             

   Example request body:

   
   {
     "SNOWFLAKE": {
       "username": "your_snowflake_user"
     }
   }
             

   The response includes the public RSA key and a reference to a securely stored private key:

   
   {
     "rsaKeys": {
       "customSecretsName": "arn:aws:secretsmanager:...",
       "publicKey": "-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9..."
     }
   }
             

2. Assign the RSA public key to your Snowflake user.

   Run the following SQL in Snowflake to assign the key:

   
   ALTER USER your_snowflake_user
   SET RSA_PUBLIC_KEY = '<paste_public_key_here>';
             

   Ensure the public key is pasted exactly as received, including header and footer lines. This step enables Reltio to authenticate securely without needing direct credentials.