Snowflake

Connect your Snowflake organization to StackSpend via the ORGANIZATION_USAGE schema.

What StackSpend tracks

StackSpend queries the SNOWFLAKE.ORGANIZATION_USAGE schema to pull compute, storage, and data transfer spend, along with credits used and credit price. Data is refreshed daily with up to 90 days of historical costs available on first sync.

Latency	Historical	Setup time
Daily	90 days	5 min

Prerequisites

A Snowflake organization account (not a standalone trial account).
A user with the ORGADMIN or ACCOUNTADMIN role — required to read ORGANIZATION_USAGE views.

Role requirement.StackSpend queries SNOWFLAKE.ORGANIZATION_USAGE, which is only accessible to users with the ORGADMIN or ACCOUNTADMIN role. Standard roles will not have visibility into these views.

Identify your account

Open the Snowflake console and click the account selector in the top-left corner. Copy your account identifier.

The format is either orgname.accountname (recommended) or accountlocator.region for older accounts.

Create a read-only user (optional but recommended)

Using a dedicated service user is safer than connecting with personal credentials. Run the following in a Snowflake worksheet as ACCOUNTADMIN or ORGADMIN:

CREATE USER stackspend_ro
  PASSWORD = '...'
  DEFAULT_ROLE = ACCOUNTADMIN;

GRANT ROLE ACCOUNTADMIN TO USER stackspend_ro;

Replace ... with a strong password. If your organization uses ORGADMIN for billing, substitute ACCOUNTADMIN with ORGADMIN in both statements.

Add to StackSpend

In StackSpend, go to Providers → Snowflake and enter the following values:

Field	Where to find it
Account Identifier	Copied from the account selector in Step 1
Username	`stackspend_ro` (or your chosen username)
Password	Password set in Step 2

Click Save to begin the first sync.

Verify

The first sync fetches 90 days of history from the ORGANIZATION_USAGE views. Data appears in StackSpend within minutes of the sync completing.

GitHub

Vercel