Snowflake cost connection
Last updated
Was this helpful?
Last updated
Was this helpful?
IP RESTRICTIONS
Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.
👉 See also: .
Paradime relies on views from the snowflake.organization_usage
such as the snowflake.organization_usage.rate_sheet_daily
view is used to retrieve your daily rate for each Snowflake service (example the cost per credit for compute resources and cost per terabyte for storage).
To verify if these views are populated in your account, please execute the following SQL statement:
To enable Paradime to enrich your Snowflake queries with additional metadata you will need to create a new dbt™️ macro called get_query_comment.sql
in the macros folder of your project.
This step ensures that with each dbt™️ run, the query comment is appended to the query running in Snowflake.
Click "Settings" in the top menu bar of the Paradime interface.
Click "Connections" in the left sidebar.
Click "Add New" next to the Radar Environment.
Select "Snowflake" as the connection type.
After selecting Snowflake, provide the following details:
Paradime Cost Database: PARADIME_COST_ANALYTICS
If using the Key-Pair auth method, simply enter:
Username: paradime_cost_user
Private Key: The Private Key generated and linked to the user. You must include the commented lines when adding the Private Key.
Passphrase (Optional): (Use the passphrase created when generating the encrypted)
If you purchased your Snowflake contract or credits through a reseller, such as the AWS Marketplace, you will not have access to the organization_usage
views even after executing the steps mentioned above to enable the ORGADMIN role.
Share a copy of your latest Snowflake invoice with the Paradime team (via chat or by emailing so that we can manually input the applicable rates for your account.
Snowflake
Check this guide on for the Snowflake user connecting to Paradime.