Snowflake
Prerequisites
- An organization account, or a regular account with ORGADMIN enabled. Only these can read the organization usage views this connector uses.
- ACCOUNTADMIN access, to run the setup script.
- Reseller-contracted Snowflake accounts cannot read the organization billing views, so this connector will not work for them.
What it costs you
This connector runs one small scheduled query a day, on a dedicated XS warehouse with auto-suspend after 60 seconds. Expect a few cents a month on your Snowflake bill.
Connect
Get your setup script
Open Connect Providers, select Snowflake, and enter your account identifier (for example myorg-myaccount). LevelFour generates a key pair and a SQL script scoped to your account.
Run the script in Snowflake
As ACCOUNTADMIN, open a Snowflake worksheet, paste the script, and run it.
The script creates a dedicated TYPE = SERVICE user authenticated by the key pair LevelFour generated, a new XS warehouse with AUTO_SUSPEND = 60, and grants that user read access only to the organization usage views LevelFour reads. It changes nothing else in your account.
Finish in LevelFour
Return to Connect Providers and click Verify. The connection completes once the script has run.
Confirming it worked
The connection moves to Connected. Your first data appears within a day.
Rotating or removing access
Rotating the credential
Generate a new script from Connect Providers. Running it issues a new key pair for the same service user; the old key stops being accepted once the new one is set.
Removing access
Disconnect Snowflake under Connect Providers, then, as ACCOUNTADMIN, drop the dedicated user and warehouse the script created.
Troubleshooting
| Symptom | What to do |
|---|---|
| The script runs, but no currency data ever appears | Your account is likely reseller-contracted. Reseller accounts cannot read the organization billing views; check with your Snowflake account team |
| The script fails to run | It must run as ACCOUNTADMIN. A role with lesser privileges cannot grant the organization usage views |
| You connected a regular account and only see one account's data | Currency data is only available from the organization account or an ORGADMIN-enabled account. A plain account sees credits for itself only, never currency |
Next
- Connect Providers lists every provider you can connect
- Databricks connects the same way, with a setup script instead of a pasted key