Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

Is there any consumption cost when you add a stream to a table in Snowflake?

6.05K views
0

Is there any consumption cost when you add a stream to a table in Snowflake?

Gisele Casillas Answered question November 8, 2021
0

Snowflake extends the data retention period for the source table temporarily when a stream is not consumed regularly.

Regardless of which edition of Snowflake you have on your account, if the data retention period for the table is less than 14 days, behind the scenes it is extended to the smaller of the stream transactional offset or 14 days (if the data retention period for the table is less than 14 days). But your monthly storage charges will be impacted if you extend the data retention period.

A stream's main cost is the processing time used by a virtual warehouse to query the stream. You see these charges on your bill as Snowflake credits.

Gisele Casillas Answered question November 8, 2021

Sign in with google.com

To continue, google.com will share your name, email address, and profile picture with this site.

Harness the Power of Data with ITS Solutions

Innovative Solutions for Comprehensive Data Management

Feedback on Q&A