How Streams work in Snowflake

Eighteenth Chapter of the Snowflake SnowPro Core Course: Streams

Gonzalo Fernandez Plaza
7 min readNov 16, 2021

--

Streams for the Snowflake SnowPro Core Certification.
Streams for the Snowflake SnowPro Core Certification.

Streams in Snowflake are perhaps one of the most complex topics of the Snowflake SnowPro Core certification, although once we understand them, all the questions will seem very simple. Let's go for it!

  1. Introduction to Streams
  2. Stream Examples
  3. Typical Exam Questions about Streams

Remember that all the chapters from the Snowflake course can be found in the following link:

INTRODUCTION TO STREAMS

Streams are Snowflake objects that record data manipulation language (DML) changes made to tables*, including INSERTS, UPDATES, and DELETES, as well as metadata about each change. Thanks to this, actions can be taken using the changed data.
*Streams didn’t work with views; however, as a new feature of March 2022, Streams now support views and secure views!

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com