Approaching Snowflake ConsumptionHeading

By Jerry Locke, Snowflake Delivery Lead

At Paradigm we pride ourselves on being agnostic.  We help you not only decide the best platform to build your cloud foundation but also help your team leverage it.  While these platforms’ capabilities are very well documented, our focus here is on the factor of cost or – as we discuss often as a Snowflake partner – consumption.

Snowflake’s approach is focused on driving customers to consumption.  Customer success is the fabric of what we are building at Paradigm and having customers see Snowflake success is critical.  Frank Slootman, Snowflake’s CEO, published a book called Amp It Up and one of the many things I took away from it that I can impart to you, the customer, is this:

So, in typical Slootman fashion let’s speak to the elephant in the room here: Snowflake makes money on your consumption.  So why would Snowflake have a vested interest in saving you, the customer money?  My answer is like as it is at Paradigm, it is about you, the customer. The most recent example of this is in Snowflake’s 2022 Q4 recent stock hit as “Executives said engineers have been rolling out efficiency improvements to the company’s software that have lowered consumption of customers credits”.  While the focus has been on revenue, it is not at the sacrifice of you, the customers.  That is the best proof – the kind that hits your wallet… in a good way!

With this relentless focus on you, the Snowflake customer, let us circle back to consumption.  When you become a customer, the cost of storage pales in comparison to the cost of consumption.  Consumption can be understood as the compute engine that powers your workload.  You can enable any number of “virtual data warehouses”, which are effectively, the compute engines that power query execution. Virtual data warehouses are available in eight “T-shirt” style sizes: X-Small, Small, Medium, Large, and X- to 4X-Large. These sizes are growing as well however, each data warehouse size has a compute credit designation. As you go up in size, credits usage will vary.

Smart Consumption with Paradigm
Paradigm’s approach to “smart” consumption is a “no pain, no gain approach” that allows your team to understand how this consumption narrative starts and speaks to your entire organization.  We call it “smart” because just like your smart phone, smart watch, or like how a Tesla is to a combustion engine, it requires you to understand, plan and know your usage patterns.  The more you plan the better you off you will be!

Anytime you embark on a cloud journey there are 3 drivers to mold your decisions.  They are (in order of importance) your people, your process, and your technology.  As a Snowflake customer, you should and will challenge the first two (people and process) naturally through your data evolution.  However, regardless of scale and urgency to power your data evolution, the cloud consumption of your Snowflake account should follow these general steps.

  1. Tag objects and/or allocate your cloud sources: Snowflake tagging is used to tag sensitive data (e.g. PII, Secret). However, it can be used for metadata so analysts can quickly identify resources that consume your Snowflake consumption.  It is a great starting point that can and should be leveraged in your Snowflake account.
  2. Know your workloads: One of the lost arts of data warehouse consumption is to really define your workloads. For the ones as old as I am and have seen the data evolution from ETL vs ELT, you will observe that the elasticity of the cloud is not a hyperbole.  Cloud consumption is a game changer and knowing your workloads is essential for true ROI.
  3. Bill back or identify ROI: Now the real fun begins! With the first 2 steps completed (tagging and knowing your workloads) the easy technical job of reporting begins.  Paradigm’s Snowflake Data Consumption Optimization puts this important initiative into play.  ROI does not have to live in your organization as a measurement for finance – through these steps it can be applied to your Snowflake account.

Consumption can be a complicated issue when compared to the traditional license models we have grown accustomed to in the data warehouse space.  In the past, we had to consider “per license” fees, and licensing audits can be costly – on both time and money.  With Snowflake, the model has changed in that anyone (yes anyone) can get access.  You are only charged for consumption used with a small cost for data storage. Understanding your workloads is the key driver here.  Then associating it to the business outcomes is what we have seen propel companies forward.  How can Paradigm help you start, continue, or enable your consumption with the knowledge of where you are spending it?  Let’s find out!


Recent Posts

Executive Perspective: Why Securing Your Data is the Key to Winning with AI

As CXOs, we’re all focused on leveraging AI to drive efficiency, innovation, and competitive advantage. The conversation often starts with infrastructure (GPUs, LLMs, and copilots), but let’s be clear: AI doesn’t run on GPUs. It runs on data. And if our data isn’t secure, nothing else matters. Unsecured and unclassified data undermines trust, exposes us to risk, and jeopardizes the very AI strategies we’re betting our futures on. It’s not about chasing the next shiny tool; it’s about building a foundation that allows AI to scale safely, responsibly, and securely.

Quantifying the Value of Data in Financial Services

In the financial services sector, data is a critical asset that drives profitability, risk management, regulatory compliance, and competitive edge. However, measuring its value remains challenging for many CFOs across sectors of the financial services industry regardless of organizational size or country of operations. CFOs rely on accurate data for forecasting, budgeting, and strategic planning. Quality data leads to better decision-making, optimized capital allocation, and swift responses to market changes. It is also vital for risk management, regulatory compliance (e.g., BCBS 239, Basel III, AML/KYC), and avoiding fines and reputational damage. “Fit for Business Use” data also supports customer retention, personalized services, and improved revenue stability. Data-savvy CFOs leverage insights for long-term growth.

AI Starts with Data: Go From Hype to Results

AI continues to dominate the conversation in business. From executive meetings to strategic roadmaps, AI is no longer just a trend but a real driver of transformation. The challenge is that while nearly every organization is talking about AI, very few are prepared to use it in a way that delivers measurable outcomes and lasting impact. The difference between hype and outcomes almost always comes down to two things: the quality of your data and your organization’s readiness to execute.

Exciting Updates from Informatica World: Paradigm Embraces the Future of Agentic AI

The digital landscape is evolving rapidly, and staying ahead means embracing the latest innovations in data management and artificial intelligence. At this year’s Informatica World, Paradigm is thrilled to share the groundbreaking advancements unveiled by Informatica, centered around their latest agentic AI solutions on the Intelligent Data Management Cloud (IDMC) platform.

Modernizing PowerCenter: The IDMC Way – Better, Faster, Cheaper

For many organizations, Informatica PowerCenter has been the workhorse of their data integration for years, even decades, reliably driving ETL processes and populating data warehouses that feed BI reports. However, this longevity often leads to a complex environment that can hinder agility and innovation.

Boost Growth with Data-Driven Hiring for Boutique Consultancies

Consistency is key to a boutique consultancy. Delivering quality services day in and day out, even as client demand fluctuates, relies heavily on having the right talent at the right time. Perhaps one of the largest operational challenges for small and mid-sized consulting firms, though, is matching recruitment cycles with cyclical demand. Without scalable, data-driven talent practices, consultancies can suffer from misaligned capacity, lost revenue streams, and stalled growth.

Strategies for a Successful Journey in Building the Dream Team

In the whirlwind world of project management, the success of a project often hinges on the strength and consistency of the team behind it. Imagine embarking on a journey where building a high-performing project team is not just about assembling a group of skilled individuals; it’s about fostering collaboration, trust, and a shared sense of purpose. Based on my personal experiences, let me take you through this journey with some strategies I use to help you build and lead a high-performing project team.

The Ultimate Guide to AI-Enhanced APIM Analytics for Enterprise Success

Enterprises increasingly rely on Application Programming Interface (API) Management (APIM) to streamline their operations, enhance customer experiences, and drive innovation. Azure API Management is a comprehensive solution enabling organizations to manage, secure, and optimize their APIs efficiently. However, beyond API management, APIM analytics – particularly when integrated with AI and data analytics – empowers senior executives with critical insights for real-time decision-making.

Why PMOs that Leverage Power BI are More Successful

Project Management Offices (PMOs) are increasingly turning to Microsoft Power BI as a game-changing tool to enhance their project management processes. By leveraging data visualization and analytics, PMOs can make informed decisions, streamline reporting, and improve overall project outcomes.