Connect Snowflake Host with Key Pair

Requirements

To complete this guide, you must be a user with the following:

• Immuta permissions:

  • APPLICATION_ADMIN

  • CREATE_DATA_SOURCE

• Snowflake permissions:

  • CREATE DATABASE ON ACCOUNT WITH GRANT OPTION

  • CREATE ROLE ON ACCOUNT WITH GRANT OPTION

  • CREATE USER ON ACCOUNT WITH GRANT OPTION

  • MANAGE GRANTS ON ACCOUNT WITH GRANT OPTION

  • APPLY MASKING POLICY ON ACCOUNT WITH GRANT OPTION

  • APPLY ROW ACCESS POLICY ON ACCOUNT WITH GRANT OPTION

Complete the following steps to connect a Snowflake host:

1. Use the /integrations/scripts/create endpoint to receive a script.

2. Run the script in Snowflake.

3. Use the /data/connection endpoint to finish creating the connection to your host and Immuta.

Step 1: Generate the script

POST /integrations/scripts/create

Copy the request and update the <placeholder_values> with your connection details. Then submit the request.

Payload parameters

Step 2: Run the script in Snowflake

Step 3: Create the host in Immuta

POST /data/connection

Copy the request and update the <placeholder_values> with your connection details. Note that the connection details here should match the ones used in step one. Then submit the request.

Test run

Opt to test and validate the create connection payload using a dry run:

POST /data/connection/test

Payload parameters

Response schema

Example response