How to Build a Snowflake Cost Chargeback and Showback Model

Chargeback vs Showback: The Difference

Showback reports how much each team or cost center consumed without actually charging them. It creates visibility and awareness. Chargeback goes further by allocating actual costs to internal budgets, making teams financially responsible for their Snowflake spend. Most organizations start with showback before moving to formal chargeback.

Step 1: Establish a Tagging Strategy

Consistent attribution requires consistent tagging. Define a standard tag schema that captures team, product, environment, and cost center. Apply tags at the warehouse level using ALTER WAREHOUSE SET TAG. For query-level attribution, use SESSION QUERY_TAG or include tags in dbt model configs. Without a tagging standard, attribution becomes guesswork.

Step 2: Build the Attribution Data Model

Your chargeback model needs to join warehouse usage with team ownership. The core tables are QUERY_HISTORY, WAREHOUSE_METERING_HISTORY, and your team ownership registry. For warehouse-based attribution, join warehouse names to your team ownership table. Allocate credits proportionally when multiple teams share a warehouse based on execution time ratios.

Step 3: Handle Shared Warehouses Fairly

When multiple teams share a warehouse, credits must be split. The fairest allocation method is proportional: assign credits to each team based on their share of total execution time within a billing period. For warehouses dedicated to a single team, direct attribution is straightforward.

Step 4: Allocate Storage Costs by Database Ownership

Storage attribution is simpler than compute. Map each database to a team in your ownership registry, then pull STORAGE_USAGE from ACCOUNT_USAGE and join to ownership data. Remember to include time travel and Fail-safe storage, which can be significant for teams with aggressive retention policies.

Step 5: Automate Monthly Reporting

Build a scheduled dbt model or stored procedure that generates monthly cost summaries by team. Include compute credits, storage costs, cloud services charges, and any Snowflake Marketplace fees. Distribute showback reports to team leads before the month closes, not after the invoice arrives.

Step 6: Set Team-Level Budgets and Alerts

Once attribution is working, formalize it with team-level budgets and automated alerts. Snowflake resource monitors can enforce credit quotas at the warehouse level. Alert at 70%, 90%, and 100% of budget, giving teams time to respond before they exceed their allocation.