See how Ramp uses ConductorOne
ConductorOne

ConductorOne Docs

Snowflake connector

Integrations with the applications from which ConductorOne pulls identity data are called connectors.

Snowflake integration

Overview

Snowflake is a popular cloud hosted data lake and analysis tool for data scientists, data analysts, and developers. Snowflake frequently contains sensitive customer information.

Availability

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

Capabilities

  • Sync identities from Snowflake to ConductorOne
  • Entitlements Supported:
    • Snowflake Roles

Requirements

When connecting to your Snowflake environment, you will need:

  • Super Administrator role in ConductorOne
  • Manage Grants global privilege in Snowflake.
    • Note: You will be required to choose a role with this privilege after the initial connector setup is complete.

Integrate your Snowflake instance

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, click Integrations > Snowflake.
  2. If this is your first Snowflake integration, the integration form opens automatically. Otherwise, click Add Connector.
  3. In the Account ID / Locator field, enter the locator you looked up in Step 1.
  4. In the Username field, enter your Snowflake account username.
  5. In the Password field, enter your Snowflake account password.
  6. Click Next.
  7. A new Snowflake page opens with your saved credentials.

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 toast, click on View logs to verify that the connector syncs successfully.

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