Snowflake
Connect Snowflake with a read-only monitor user that reads ACCOUNT_USAGE views.
OpsLyft reads Snowflake cost from the SNOWFLAKE.ACCOUNT_USAGE views through a read-only monitor user. OpsLyft generates the SQL for you; you run it once. It takes about two minutes.
Before you begin
You need to run SQL as ACCOUNTADMIN (or a role that can create users and grant access to ACCOUNT_USAGE).
Connect Snowflake
Generate the SQL snippet
Choose Snowflake and select Generate SQL snippet. Copy the snippet.
Run it as ACCOUNTADMIN
Open a Snowflake worksheet, switch to ACCOUNTADMIN, paste the snippet, and run it. It creates a user and role with read access to ACCOUNT_USAGE only.
Paste your account locator
Paste your account locator back into OpsLyft. OpsLyft verifies the connection and starts reading.
Read-only
The monitor user can read usage views. It can't read your tables, run your warehouses on its own schedule, or change anything.
What OpsLyft reads
| Data | Used for |
|---|---|
| Warehouse metering and credit usage | Cost by warehouse, schedule opportunities such as Always-on warehouse with off-hours idle |
| Storage usage | Storage cost by database |
| Serverless and cloud services credits | Full Snowflake cost |
Data freshness
ACCOUNT_USAGE views update with a delay of up to a few hours. See Data freshness.
Related
- The
warehouse_creditsexample dataset shows how to join Snowflake usage to your own data. See Datasets.