tsnowflakeoutput connection for DML action UPDATE on target is not working

Four Stars

tsnowflakeoutput connection for DML action UPDATE on target is not working

Hi,

 

I am trying to implement Change data capture with the tsnowflakeoutput component but am getting below error, Please assist 

[statistics] connecting to socket on port 3519 [statistics] connected Exception in component tSnowflakeOutput_2 (CDC_IMPLEMENTATION)
net.snowflake.client.loader.Loader$ConnectionError: Updating operations require keys
at net.snowflake.client.loader.StreamLoader.validateParameters(StreamLoader.java:257)
at net.snowflake.client.loader.StreamLoader.start(StreamLoader.java:211)

Moderator

Re: tsnowflakeoutput connection for DML action UPDATE on target is not working

Hello,

The CDC feature, introduced in Talend Studio, simplifies the process of identifying the change data since the last extraction.Which is database you are using?

Could you please show us your job design screenshots? Have you already checked online user guide about:TalendHelpCenter:Change Data Capture (CDC): publish/subscribe?

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tsnowflakeoutput connection for DML action UPDATE on target is not working

I am using Snowflake as my target DB with source as MS SQL server .Can you please suggest