Availability

✅ General availability. The Snowflake integration is available to all ConductorOne users.

Capabilities

• Sync user identities from Snowflake to ConductorOne

• Resources supported:

  • Roles

Set up the Snowflake integration

This task requires either the Integration Administrator or Super Administrator role in ConductorOne.

1. In ConductorOne, open Admin and click Integrations > Snowflake.

2. If this is your first Snowflake integration, the integration form opens automatically. Otherwise, click Add connector.

3. Choose whether to add the new Snowflake connector as a data source to an existing application (and select the app of your choice) or to create a new application.

   Do you SSO into Snowflake using your identity provider (IdP)? If so, make sure to add the connector to the Snowflake app that was created automatically when you integrated your IdP with ConductorOne, rather than creating a new app.

4. Set the integration owner for this connector. You can manage the integration yourself, or choose someone else from the list of ConductorOne users. Setting multiple integration owners is allowed.

   A Snowflake integration owner must have the following permissions:

   • Integration Administrator or Super Administrator role in ConductorOne
   • Manage Grants global privilege in Snowflake

5. Click Create and add details.

Next steps

• If you are the integration owner, proceed to Integrate your Snowflake instance for instructions on integrating Snowflake with ConductorOne.

• If someone else is the integration owner, ConductorOne will notify them by email that their help is needed to complete the integration.

Integrate your Snowflake instance

A user with the Integration Administrator or Super Administrator role in ConductorOne and Manage Grants global privilege in Snowflake must perform this task.

You will be required to choose a Snowflake role with Manage Grants global privilege after the initial connector setup is complete.

Step 1: Locate the Snowflake Locator for your account

1. In Snowflake, click Organization.

2. Locate the account you wish to connect to ConductorOne in the accounts list.

3. Hover over the value in the LOCATOR column, and click the copy function. We’ll use this in Step 2.

   

Step 2: Add your Snowflake credentials to ConductorOne

1. In ConductorOne, open Admin and click Integrations > Snowflake.

2. In the list of connectors, locate and click on the name of the connector with the Not connected label.

3. Find the Settings area of the page and click Edit.

4. In the Account ID / Locator field, enter the locator you looked up in Step 1.

5. In the Username field, enter your Snowflake account username.

6. In the Password field, enter your Snowflake account password.

7. Click Save.

8. The connector’s label changes to Syncing, followed by Connected. You can view the logs to ensure that information is syncing.

Step 3: Choose a role in Snowflake

1. In Snowflake, go to User roles and click Edit.

   

2. Select a user role. A role that’s equivalent to SECURITYADMIN is required.

   

3. Click Add User role.

4. Click Save.

5. Return to ConductorOne. After you see the Connector updated message, click on View logs to verify that the connector syncs successfully.

That’s it! Your Snowflake instance is now integrated with ConductorOne.

Configure the Snowflake integration using Terraform

As an alternative to the integration process described above, you can use Terraform to configure the integration between Snowflake and ConductorOne.

See the ConductorOne Snowflake integration resource page in the ConductorOne Terraform registry for example usage and the full list of required and optional parameters.