# Inefficient pipeline refresh scheduling | Cloud Efficiency Hub Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/inefficient-pipeline-refresh-scheduling Inefficient pipeline refresh scheduling occurs when data refresh operations are executed more frequently, or with more compute resources, than the... By: Simar Arora Updated: 2026-09-28 [Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) # Inefficient Pipeline Refresh Scheduling [Simar Arora](https://www.linkedin.com/in/simarpreet-arora/) Value Engineer - FinOps @ Snowflake Snowflake service [Snowflake Tasks and Pipelines](https://www.pointfive.co/efficiency-hub/cloud-services/snowflake-tasks-and-pipelines) Category [Other](https://www.pointfive.co/efficiency-hub/service-category/other) Reference CER-0025 Type Inefficient Architecture ## Explanation Why the waste happens and who it affects. Inefficient pipeline refresh scheduling occurs when data refresh operations are executed more frequently, or with more compute resources, than the actual downstream business usage requires. Without aligning refresh frequency and resource allocation to true data consumption patterns (e.g., report access rates in Tableau or Sigma), organizations can waste substantial Snowflake credits maintaining underutilized or rarely accessed data assets. ## Billing model The pricing dimensions that drive this cost. - Tasks that run on a user-managed virtual warehouse consume credits at an hourly rate set by the warehouse size (for example, Small is 2 credits per hour and Medium is 4), billed per second with a 60-second minimum each time the warehouse starts or resumes. Frequent short refreshes on a warehouse that suspends between runs pay that minimum on every resume. - Serverless tasks are billed for the compute resources Snowflake assigns to each run, at the rates in the Snowflake Service Consumption Table. - Dynamic tables refresh on a warehouse according to their target lag, and every refresh cycle also runs change-detection checks that consume Cloud Services credits; Cloud Services credits are billed only when the account's daily Cloud Services usage exceeds 10% of that day's warehouse compute credits. - This inefficiency is driven by refresh frequency and warehouse size: every refresh consumes credits whether or not anyone reads the refreshed data. ## How to detect 3 checks to find it in your estate. - Review the execution frequency and resource consumption (warehouse size, task duration) of scheduled pipelines and tasks Map data lineage to understand which downstream assets (e.g., dashboards, reports) depend on each refreshed dataset - Analyze BI tool usage metrics (e.g., Tableau, Sigma) to assess the frequency of access to downstream data consumers - Identify pipelines where the refresh cost is high relative to the actual business consumption of the refreshed data ## How to fix 4 ways to remove the waste. - Adjust pipeline refresh frequencies to better align with actual data access patterns (e.g., move from hourly to daily refresh if applicable) - Right-size the warehouse resources used for pipeline executions to minimize overprovisioning - Implement usage monitoring frameworks that continuously correlate refresh costs with downstream consumption - Periodically review pipeline operational costs and business value to optimize refresh schedules proactively ## Documentation Vendor references for pricing and configuration. - [Understanding compute cost docs.snowflake.com](https://docs.snowflake.com/en/user-guide/cost-understanding-compute) - [Introduction to tasks docs.snowflake.com](https://docs.snowflake.com/en/user-guide/tasks-intro) - [Understanding costs for dynamic tables docs.snowflake.com](https://docs.snowflake.com/en/user-guide/dynamic-tables/cost) - [Exploring compute cost docs.snowflake.com](https://docs.snowflake.com/en/user-guide/cost-exploring-compute) ## Related inefficiencies [Browse the library](https://www.pointfive.co/efficiency-hub) - Snowflake Materialized Views CER-0026 ### [Missing or Inefficient Use of Materialized Views](https://www.pointfive.co/efficiency-hub/inefficiencies/missing-or-inefficient-use-of-materialized-views) Inefficiency arises when MVs are either underused or misused. When high-cost, repetitive queries are not backed by MVs, workloads consume unnecessary compute resources. When MVs exist but are rarely queried, their background refresh and... Other - Snowflake Query Processing CER-0029 ### [Suboptimal Query Routing](https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-query-routing) Organizations may experience unnecessary Snowflake spend due to inefficient query-to-warehouse routing, lack of dynamic warehouse scaling, or failure to consolidate workloads during low-usage periods. Snowflake now offers Adaptive... Other - Snowflake Search Optimization Service CER-0131 ### [Suboptimal Use of Search Optimization Service](https://www.pointfive.co/efficiency-hub/inefficiencies/suboptimal-use-of-search-optimization-service) Search Optimization can enable significant cost savings when selectively applied to workloads that heavily rely on point-lookup queries. By improving lookup efficiency, it allows smaller warehouses to satisfy performance SLAs, reducing... Other --- Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.