Loading data in Snowflake
Stream Pipelines uses Snowflake's Snowpipe
Streaming technology to enable low-latency streaming and direct writing of data rows into the
Snowflake tables.
When data is transmitted to the Snowflake connector, the stream pipelines are restricted only to inserting data.
Unlike other destination technologies, the option to load data with the Stream Pipelines' upsert method is not available for the Snowflake destination.