PublishChangeDataSnowpipeStreaming 2026.4.28.15

Bundle

com.snowflake.openflow.runtime | runtime-snowpipe-streaming-2-processors-nar

Description

Publishes change data records formatted as Newline Delimited JSON to Snowflake Database Pipes using Snowpipe Streaming High Availability. The processor supports Concurrency Group serialization so FlowFiles that share the same group are not processed against the channel concurrently.

After data is transferred, the processor waits for the streaming channel to report committed offset tokens (according to Offset Tracking Resolution and Offset Tracking Timeout) before routing FlowFiles to success, invalid, or failure. It can run when the incoming connection has no FlowFiles so that pending batches finish polling.

Tags

CDC, Change Data Capture, NDJSON, Preview, Snowflake, Snowpipe Streaming

Input Requirement

REQUIRED

Supports Sensitive Dynamic Properties

false

Properties

PropertyDescription
AccountSnowflake Account Identifier with Organization Name and Account Name formatted as [organization-name]-[account-name]
Authentication StrategyStrategy for authenticating Snowflake connections
Channel GroupGroup for managing distinct Snowpipe Streaming Channels with partitioning
Channel Insert TimeoutMaximum duration to retry inserting records before failing with an upper bound of 5 minutes
Concurrency GroupControls access to the configured channel with serialized claims according to the configured value or expression
DatabaseSnowflake Database destination for processed records
Destination TypeSnowflake destination object for processed records with support for derived default pipes
Offset Token End ExpressionExpression Language definition to produce the highest offset token for a FlowFile as a monotonically increasing number
Offset Token Record PointerJSON Pointer to offset token in each record required when the last committed offset token is between start and end boundaries
Offset Token Start ExpressionExpression Language definition to produce the lowest offset token for a FlowFile as a monotonically increasing number
Offset Tracking ResolutionResolution level for evaluating committed offset tokens against input FlowFiles and records. Disabled: opaque offset token handling without tracking across FlowFiles or records. FlowFile: track each FlowFile with monotonically increasing offset tokens. Record: track each record in each FlowFile with monotonically increasing offset tokens.
Offset Tracking TimeoutMaximum duration to wait for channel status to confirm committed offset tokens before routing to failure
PipeSnowflake Pipe destination for processed records
Private Key ServiceRSA Private Key Service for authenticating connections
RoleSnowflake Role the user will assume when authenticating connections
SchemaSnowflake Schema destination for processed records
TableSnowflake Table destination for processed records
Transfer StrategyStrategy for transferring records to Snowpipe Streaming. Managed: transfer records as either batches of rows or file fragments based on uncompressed size. Rows: transfer records as batches of rows over HTTP to Snowpipe Streaming. File Fragments: transfer records as file fragments over HTTP to cloud storage services.
UserSnowflake User for authenticating connections
Web Client Service ProviderWeb Client Service Provider supporting HTTP request and response handling

Relationships

NameDescription
emptyFlowFiles with empty content not sent to Snowflake
failureFlowFiles that failed to upload to Snowflake
invalidFlowFiles that Snowflake identified as containing one or more invalid rows resulting in partial transmission
successFlowFiles successfully uploaded to Snowflake