Understanding Billing for Snowpipe Usage

With Snowpipe’s serverless compute model, users can initiate any size load without managing a virtual warehouse. Instead, Snowflake provides and manages the compute resources, automatically growing or shrinking capacity based on the current Snowpipe load. Accounts are charged based on their actual compute resource usage; in contrast with customer-managed virtual warehouses, which consume credits when active, and may sit idle or be overutilized.

In this Topic:

Resource Consumption and Management Overhead

Snowflake tracks the resource consumption of loads for all pipes in an account, with per-second/per-core granularity, as Snowpipe actively queues and processes data files. Per-core refers to the physical CPU cores in a compute server. The utilization recorded is then translated into familiar Snowflake credits, which are listed on the bill for your account.

Note

Using a multi-threaded client application enables submitting data files in parallel, which initiates additional servers and loads the data in less time. However, the actual overall compute time required would be identical to using a single-threaded client application, just spread out over more internal Snowpipe servers.

In addition to resource consumption, an overhead to manage event notifications (for files added in cloud storage) is included in the utilization costs charged for Snowpipe (regardless if the notifications result in data loaded or not). This overhead increases in relation to the number of files added in cloud storage. Snowpipe charges 0.06 credits per 1000 event notifications received.

Decisions with regard to data file size and staging frequency impact the cost and performance of Snowpipe. For recommended best practices, see Continuous Data Loads (i.e. Snowpipe) and File Sizing.

Viewing the Data Load History for Your Account

Account administrators (users with the ACCOUNTADMIN role) or users with a role granted the MONITOR USAGE global privilege can use the Snowflake web interface or SQL to view the credits billed to your Snowflake account within a specified date range.

To view the credits billed for Snowpipe data loading for your account:

Web Interface

Click on Account Account tab » Billing & Usage. Snowpipe utilization is shown as a special Snowflake-provided warehouse named Snowflake logo in blue (no text) SNOWPIPE.

SQL

Query the PIPE_USAGE_HISTORY table function (in the Information Schema).

Note

Resource monitors provide control over virtual warehouse credit usage; however, you cannot use them to control credit usage for the Snowflake-provided warehouses, including the Snowflake logo in blue (no text) SNOWPIPE warehouse.