ClickUp adopted proactive FinOps strategy for Snowflake before costs ballooned

SELECT provided comprehensive cost visibility that ClickUp's homegrown solution aimed to achieve, with quick and straightforward setup. The platform's automated insights eliminated manual legwork of cost analysis while enabling granular monitoring down to individual dbt models. Weekly Slack digests created a macro-to-micro approach for efficient, ongoing cost management.

ClickUp operates a modern data stack with Snowflake serving as the definitive source of truth across the company. The platform supports hundreds of users including data engineers, analysts, and business stakeholders who are able to run direct queries after completing ClickUp's homegrown SQL training course. Beyond direct query access, Snowflake powers ClickUp's entire operational ecosystem. Census enables reverse ETL to push data from Snowflake to power marketing campaigns, RevOps workflows, and sales operations across tools like Salesforce, Pocus, and various ESP platforms. This warehouse-first approach means that changes made in Snowflake propagate throughout ClickUp's entire operational infrastructure, making cost management and optimization critical for both data platform stability and business operations.

Before SELECT, ClickUp built internal cost monitoring using open-source dbt monitoring packages. Using this metadata, the team built custom cost monitoring dashboards in Tableau and later Hex. While the homegrown solution provided basic visibility, it became increasingly difficult to maintain as ClickUp's Snowflake usage scaled. The team recognized they needed a more sustainable approach that wouldn't require ongoing engineering investment.

ClickUp's adoption of SELECT was driven by a proactive cost management philosophy rather than reactive cost problems. Michael recognized the importance of establishing proper cost monitoring infrastructure before issues emerged. This forward-thinking approach aimed to prevent the common scenario where finance suddenly demands cost cuts for critical infrastructure that teams can't afford to eliminate.

SELECT transformed ClickUp's cost management approach through automated weekly Slack digests that provide high-level cost trending with the ability to drill down when needed. This systematic approach prevents wasted time on micro-optimizations while ensuring no significant cost increases go unnoticed. When alerts indicate cost growth, the team can quickly identify whether issues stem from warehouse optimization needs, user behavior, or dbt model inefficiencies.

SELECT's visibility immediately surfaced several cost optimization opportunities that ClickUp's homegrown solution had missed. One major discovery involved Census configurations where marketing teams had set up live syncs for audiences despite ClickUp's batch data processing. The team also identified users forgetting to switch back from larger warehouses after ad hoc analysis work and opportunities for warehouse consolidation across tools with similar usage patterns. Additional optimizations included incrementalizing expensive dbt models and switching table types from permanent to transient for appropriate use cases.

Perhaps the most significant cultural change was embedding cost considerations into every data project and decision. SELECT's visibility created a culture where team members proactively think about how their actions impact costs and feel accountable for their Snowflake usage. As ClickUp prepares for major infrastructure changes including real-time data ingestion, Iceberg adoption, and team expansion, SELECT will serve as the foundation for managing cost growth alongside business growth.