Hi, we are using a framework to load about 60 tables from salesforce to snowflake. I want to update the existing record if there is an update in the source. But as we are using dynamic schema I am clueless how to implement this. Please provide your suggestions. If we have the solution we will implement the same for other sources as well(SQLserver)
Hi, you could have issue with dynamicShema to set a primary key , you could force it in the Dynamic metadata with the setKey() function but you have to know the name of the primary key column or it position.
