Retrieve DML Statements ata from target table

Prerequisites: You must have access to the Snowflake database and a valid Snowflake CDC Account.

The following example pipeline demonstrates how to capture the data changes from the Insert, Update, and Delete statements executed on the EMPLOYEE table associated with EMPLOYEE_CHANGES stream.


Snowflake CDC pipeline overview
Download this pipeline
  1. Configure the Snowflake CDC as shown below to extract the executed Insert, Update, and Delete statements data.

    Snowflake CDC Snap configuration

  2. Validate the pipeline. On validation, the Snap queries the data and displays the retrieved results in the output preview.


To successfully reuse pipelines:
  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.