Menu

Before You Renew Snowflake, Run These 6 Queries
📰

Before You Renew Snowflake, Run These 6 Queries

#hackernoon#technology#date#round#query
Reading 0:00
15s threshold

Snowflake renewals have an odd shape. The contract is negotiated by people who rarely open ACCOUNT_USAGE . The usage comes from people who rarely see the contract. Then, a few weeks before the term ends, finance asks data a simple question: how much should we commit to next year? And data finds out it doesn't have a crisp answer.

I sit between finance and data, so that question tends to land with me. These are the six queries I'd run before the call. Most need ACCOUNTADMIN , or a role that's been granted access to the SNOWFLAKE database. The two that read ORGANIZATION_USAGE need organization-level access.

1. Where the money actually goes

Before anything else, split spend by service. Compute is usually the biggest line, but serverless features, storage, and data transfer add up, and they don't respond to the same fixes.

-- Spend by month and service, last 12 full months.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.