ConsumeSnowflakeStream 2025.10.9.21

Bundle

com.snowflake.openflow.runtime | runtime-snowflake-processors-nar

Description

Fetches data from a Snowflake stream and writes it to a FlowFile. The stream must be created in the database before using this processor. The processor will consume the stream and write the records to the FlowFile using the specified Record Writer. The processor will also add an attribute to the FlowFile with the name of the stream. The processor will not work if the stream is stale. Instead it will log an error message and stop processing. Stale stream has to be recreated in the database. After the stream is recreated in the database the processor will continue to read and process CDC records. For more information on Snowflake streams, see the <a href=”https://docs.snowflake.com/en/user-guide/streams-intro”>snowflake documentation</a>.

Tags

connection, database, jdbc, openflow, snowflake, stream, table, view

Input Requirement

FORBIDDEN

Supports Sensitive Dynamic Properties

false

Properties

PropertyDescription
Max Chunk SizeNumber of records to write into a single FlowFile. This value might be slightly exceeded.
Record WriterThe Record Writer to use for CDC record serialization
Snowflake Connection ServiceDatabase Connection Service for accessing Snowflake
Stream NameThe name of the stream in the database

Relationships

NameDescription
successFor FlowFiles with stream CDC records

Writes attributes

NameDescription
snowflake.stream.nameName of the Snowflake Stream