Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-01-16 12:07 PM

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)

Labels (4)
Labels
80 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2018-01-19 02:46 AM
Author

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

 

80 Views
0 Likes
Anonymous
Not applicable
‎2018-02-01 08:23 AM
Author

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

80 Views
0 Likes