Skip to main content

Connect Snowflake

DoiT Cloud Navigator: Enhanced and above
Info

In order to use Snowflake data in DoiT Navigator, we create a warehouse called DOIT_WAREHOUSE on your behalf, not to interfere with any of your own warehouses. Since we run queries several times per day, for about 15 minutes at a time, this will have a cost of US$1 per day, approximately.

To see the exact charge for the DOIT_WAREHOUSE, read about billing considerations.

Required permissions​

To connect your Snowflake account with DoiT, you need specific permissions in both your DoiT and Snowflake accounts.

Required permissions in your DoiT account​

In your DoiT account, you need the Billing Profiles Admin permission, which is included in the Finance User and Admin roles. If your role is custom, to make sure your role has this permission:

  1. Sign in to the DoiT console.

  2. Select the gear icon () from the top navigation bar, and then select Identity & access.

  3. Use the filter to find your user by entering your email or your name.

  4. Select your email, and then select the Permissions from the left-hand menu.

    Check whether the Billing Profiles Admin permission is listed under Role Entitlements.

Required permissions in your Snowflake account​

Warning

If you signed your Snowflake contract through a Snowflake reseller, you cannot connect Snowflake with DoiT.

In order to connect your Snowflake account to DoiT Cloud Navigator, you need to have an active Snowflake subscription with administrator permissions.

Connect your Snowflake account​

To connect your Snowflake account to DoiT Cloud Navigator:

  1. Sign in to the DoiT console.

  2. In the Connect your Snowflake account pane on the Welcome page, select Get started to open the Snowflake step-by-step wizard.

    Connect your Snowflake account

Alternatively, you can connect your Snowflake account:

  • In the Assets page under Billing. From the left-hand menu, select Snowflake and then select Connect your account.

  • Through the Snowflake Lens dashboard, in the Dashboards page.

Set up the connection between DoiT and Snowflake​

When you set up the connection, you'll run a script we'll provide for you in your Snowflake account. This script creates the following in your account:

  • A DoiT role with these Snowflake permissions:

    • "ORGANIZATION_USAGE_VIEWER"
    • "GOVERNANCE_VIEWER"
    • "ORGANIZATION_BILLING_VIEWER"
    Info

    Learn more about Snowflake database roles.

  • A DoiT user with the DoiT role above

  • A DoiT warehouse

To set up the connection between your Snowflake account and DoiT Cloud Navigator:

  1. In the DoiT console, go to the second step from the Snowflake step-by-step wizard.

  2. Sign in to the Snowflake console using an account with administrator permissions.

  3. Select Projects and Worksheets, and open a worksheet.

  4. Copy the script from the step-by-step wizard, and paste it in the Snowflake worksheet.

Snowflake onboarding wizard

  1. At the top of the worksheet, select a warehouse to run the script.

  2. Select a role to run the worksheet as, and expand the Run button to select Run All.

  3. Back in the step-by-step wizard in the DoiT console, enter:

    • Your Snowflake account ID, which you can find in the URL: https://app.snowflake.com/ORGANIZATION_ID/ACCOUNT_ID

    • Your Snowflake organization ID, which you can find in the URL: https://app.snowflake.com/ORGANIZATION_ID/ACCOUNT_ID

    Tip

    To learn more about your account and organization ID, see Snowflake's documentation.

Test your Snowflake connection with the DoiT console​

To test your Snowflake connection with DoiT:

  1. In the DoiT console, go to the last step from the step-by-step wizard, and select Test connection.

  2. Once the test is successful, select Done.

Billing considerations​

To see exactly how much you're charged for the DOIT_WAREHOUSE warehouse each month:

  1. Sign in to the DoiT console, select Analytics from the top navigation bar, and then select Reports.

  2. Select Create new report and use the following parameters:

  • Metric: Cost
  • Time
    • Time range: Last 3 months (include current month)
    • Time interval: Month
  • Filters
    • Provider: Snowflake
  • Group by: Snowflake warehouse name and select DOIT_WAREHOUSE.

  1. Select Save and then, Run report.

    DOIT_WAREHOUSE cost per month

What's next​

After you successfully connected your Snowflake account, we start importing your billing data. The process can take up to one hour, and we notify you when the data is available for Cloud Analytics and other DoiT features.

See also

To start monitoring your Snowflake data out of the box, check out the Snowflake Lens.

Interactive demo​

Try out our interactive demo for a hands-on walk-through experience.

Tip

If you can't see the demo properly, expand your browser window or open it in a new tab.

Last updated on