Performance Monitoring and Tuning · Topic 12 of 16

Data Transfer, Replication, Storage and Credit Costs

Calculate Snowflake data transfer, replication, storage and credit costs: which views to query, what drives each bill and the techniques that reduce it.

  • 5 min
In a nutshell
  • Transfer is billed when data leaves for another region or cloud; same region is free.
  • Replication cost = transfer plus refresh compute plus storage in the target.
  • Storage views: STORAGE_USAGE, DATABASE_STORAGE_USAGE_HISTORY, TABLE_STORAGE_METRICS.

What it is

A Snowflake bill has three main parts: compute (credits), storage, and data transfer. An administrator should be able to say which part grew, which view proves it and which lever lowers it.

Replication touches all three. It moves data between accounts (transfer), stores a copy (storage) and runs refreshes on serverless compute (credits).

Billgrowssplit byComputecreditsandStorageTB per monthandData transferout of region or cloudfix withRight lever

How it works

Data transfer costs

Snowflake bills data transfer when data leaves your account to a different region on the same cloud, or to a different cloud. Data moved inside the same region is free, and ingress is not billed by Snowflake, although your cloud storage provider may charge egress fees on its side.

Activity that can cause transfer costNotes
COPY INTO <location> unloading to storage in another region or cloudUnload close to the account when possible
Replicating databases or groups to another region or cloudCharged on the bytes replicated
External functions and external network access callsLeaves the account
Cross-Cloud Auto-Fulfillment of listingsReplication to another cloud or region
Output stage in another region or cloudFiles copied across regions

Snowflake does not bill egress when a client retrieves query results across regions or clouds.

Views for transfer:

  • SNOWFLAKE.ACCOUNT_USAGE.DATA_TRANSFER_HISTORY: bytes transferred by source and target cloud and region.
  • SNOWFLAKE.ORGANIZATION_USAGE.DATA_TRANSFER_HISTORY: the same across accounts, with 24 hours latency.

Replication costs

Replication cost has two parts: data transfer for the bytes sent to a region or cloud different from the source, and compute for the refresh work. Both are billed to the target account, the one that holds the secondary. Each secondary also keeps its own copy of the data, and its storage is billed in the target account too.

ViewShows
ACCOUNT_USAGE.REPLICATION_GROUP_USAGE_HISTORYCredits and bytes for replication and failover groups
ACCOUNT_USAGE.REPLICATION_USAGE_HISTORYCredits and bytes for database replication
ORGANIZATION_USAGE.REPLICATION_USAGE_HISTORYReplication across accounts of the organization

Cost levers: replicate only the databases and object types you need, lengthen the refresh interval, and avoid very frequent refreshes of large, high churn tables.

Exam tip

A scenario that says "replication costs went up after we shortened the schedule" is a refresh frequency question. More frequent refreshes mean more compute and more bytes moved.

Storage usage

Storage is billed per terabyte per month on the average daily compressed bytes. It includes table data, Time Travel and Fail-safe bytes, stage files and data kept alive for clones.

ViewUse
ACCOUNT_USAGE.STORAGE_USAGEDaily total storage for the account
ACCOUNT_USAGE.DATABASE_STORAGE_USAGE_HISTORYDaily storage per database
ACCOUNT_USAGE.TABLE_STORAGE_METRICSPer table bytes, including TIME_TRAVEL_BYTES, FAILSAFE_BYTES and RETAINED_FOR_CLONE_BYTES
ACCOUNT_USAGE.STAGE_STORAGE_USAGE_HISTORYStorage used by stages

A table with a large TIME_TRAVEL_BYTES or FAILSAFE_BYTES value is a high churn table; shorter retention or a transient table cuts that cost. A large RETAINED_FOR_CLONE_BYTES value means a clone still references data the source has already dropped.

Credit consumption

Credits come from three places:

SourceHow billedView
Virtual warehousesCredits per hour by size, billed per second with a 60 second minimum each time the warehouse startsWAREHOUSE_METERING_HISTORY
Serverless featuresCredits for compute Snowflake runs for youFeature views such as AUTOMATIC_CLUSTERING_HISTORY and PIPE_USAGE_HISTORY
Cloud servicesBilled only if daily cloud services use exceeds 10 percent of daily warehouse creditsMETERING_DAILY_HISTORY

METERING_HISTORY gives hourly credits for warehouses, cloud services and serverless features. METERING_DAILY_HISTORY gives daily credits and applies the cloud services adjustment through the columns CREDITS_USED_CLOUD_SERVICES and CREDITS_ADJUSTMENT_CLOUD_SERVICES. Snowsight and most other views do not apply that adjustment.

To calculate what you were billed for in a day, use:

CREDITS_BILLED = CREDITS_USED_COMPUTE + CREDITS_USED_CLOUD_SERVICES + CREDITS_ADJUSTMENT_CLOUD_SERVICES

The adjustment is a negative number, so the cloud services credits that fall under the 10 percent threshold are not charged.

Cost optimization techniques

TechniqueEffect
Set AUTO_SUSPEND low and AUTO_RESUME onStops idle compute credits
Right size warehouses and use multi cluster only when queues appearAvoids paying for unused capacity
Resource monitors and BudgetsAlerts and suspension before overspend
Transient tables and short retention for rebuildable dataLess Time Travel and Fail-safe storage
Tags and query tagsChargeback by team or project
Filter on clustering columns, avoid SELECT *Less data scanned, shorter runtime
Limit replication scope and frequencyLower transfer and refresh cost
Find the costCost Management or usage viewstag and attributeOwnerteam or projectapply leverAuto suspend, sizing, retentionand monitorsverifyLower credits next period

Common mistakes

Assuming same region replication is billed as transfer. Transfer is billed only across regions or clouds.

Looking only at table size for storage cost. Time Travel, Fail-safe and clone retained bytes count.

Using Snowsight totals as the invoice for cloud services. The 10 percent adjustment is not applied there.

Blaming ingress. Snowflake does not bill ingress.

What to remember for the exam

  • Transfer is billed when data leaves for another region or cloud; same region is free.
  • Replication cost = transfer plus refresh compute plus storage in the target.
  • Storage views: STORAGE_USAGE, DATABASE_STORAGE_USAGE_HISTORY, TABLE_STORAGE_METRICS.
  • Warehouses bill per second with a 60 second minimum on each start.
  • METERING_DAILY_HISTORY shows billed cloud services after the 10 percent adjustment.

Check yourself

  • Which view tells you how many bytes were sent to another region?

    DATA_TRANSFER_HISTORY in ACCOUNT_USAGE (or ORGANIZATION_USAGE for all accounts).

  • Where do you see Time Travel and Fail-safe bytes per table?

    TABLE_STORAGE_METRICS, in TIME_TRAVEL_BYTES and FAILSAFE_BYTES.

  • Which view shows cloud services credits actually billed?

    METERING_DAILY_HISTORY, using the adjustment column.

Topic 12 of 16 in Performance Monitoring and Tuning

Test yourself on Performance Monitoring and Tuning

The full Snowflake ADA-C02 question bank has 814 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.