Thank you John, so turning off upsert mode - does that involve setting the Apply changes using SQL merge? Or changing Apply Conflicts to do what exactly?
1. Qlik Replicate generates the apply SQL statements
Regular mode: Qlik Replicate generates standard INSERT, UPDATE & DELETE SQL statements, corresponding directly to the operations in the source database.
UPSERT mode: Similar to regular mode for INSERT and DELETE. However, source UPDATE operations are translated into a pair of operations: DELETE followed by INSERT.
2. Snowflake MERGE functionality
If “Apply changes using SQL MERGE” is enabled in the task settings, Qlik Replicate will not generate separate INSERT, UPDATE or DELETE statements. Instead, it will use Snowflake’s MERGE functionality, where a single MERGE statement handles all three types of source operations.
Note: When “Apply changes using SQL MERGE” is enabled, the Apply Conflicts error-handling policy is automatically preset and cannot be modified. In addition, some related configuration options will not be available.
Regards,
John.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Again, thank you John. How do I make sure Qlik Replicate is in Regular mode?
Do I just make sure apply conflicts has: No record found when applying DELETE: Ignore record Duplicate key when applying INSERT: Log record to the exceptions table No record found for applying an UPDATE: Log record to the exceptions table
