Cloudability Connect Snowflake

Edit online
You can connect your Snowflake account to Cloudability to enable the ingestion of cost and usage data.
Note:

It takes 4 to 24 hours before your initial cost and usage data appears in Cloudability. During this time, a message indicates that the process is yet to complete.

Note:

It If you are purchasing Snowflake via a cloud provider marketplace and adding cost and usage data for Snowflake with this integration, you will see costs displayed twice in Cloudability reporting. As an example, if you purchased Snowflake via the AWS Marketplace, you would have:

  • The high-level line item for AWS.

  • The line items with detailed Snowflake costs and AWS Marketplace listed as Seller.

You will need to set up filters or views to hide your Marketplace costs. Marketplace costs are excluded from billing.

Before you start

  • You are a Cloudability administrator.

  • You have admin permissions in the Snowflake console.

Steps for integration

Login to Snowflake Account

Access your Snowflake account using appropriate credentials to view account details.

Find Organization and Account Name
  1. Navigate to Snowsight - the web-based SQL editor for Snowflake.
  2. Open the account selector from the bottom left menu bar. This displays a list of accounts previously accessed.
  3. Identify the account name, and then select the account.
  4. Hover over the selected account to view additional details.
  5. Copy the Organization Name and the Account Name details.

Input Account Information into Cloudability
  1. Navigate to the Cloudability application, and click on Vendor Credentials under Settings in the left-hand menu.
  2. Provide the following information:

    • Organization Name : Paste the previously copied organization name from Snowflake.

    • Snowflake Account Name : Paste the previously copied account name from Snowflake.

    • Warehouse Name : Provide the name of an existing Snowflake warehouse.

    • Database Name (For Cloudability ): Specify a name for the database to be created by Cloudability.

    • User Name (for Cloudability ): Specify a name for the user to be created by Cloudability. A role with the same name suffixed with the _role will also be created.

Generate Template

Once all inputs are provided, click Vendor Credentials > Generate Template .

This will generate the template as a text file containing configuration details based on earlier input variables.

Input Template into Snowflake
  1. Copy the content of the generated text file.
  2. Paste the content into the appropriate worksheet or configuration file within the Snowflake Account. Ensure that you have the Account Admin role in Snowflake.
  3. Run the provided SQL query and wait till all the statements are executed successfully.
Verify Credentials.
  1. Return to Cloudability and navigate to the Vendor Credentials screen.
  2. Click Verify Credentials to confirm the integration status.

    If the check box is Green, you have successfully integrated Snowflake.

    Note:

    Private links and tags are not yet supported for Snowflake.