I have a snowflake table. This table has to be compared with an SQL table. If there are any matching IDs, the entire row of that ID should be updated in SQL. If not, insert entire rows to SQL(Basically, upsertion of SQl table).Can this be implemented?

Matillion ETL
1

I have a snowflake table. This table has to be compared with an SQL table. If there are any matching IDs, the entire row of that ID should be updated in SQL. If not, insert entire rows to SQL(Basically, upsertion of SQl table).Can this be implemented?

2

My understanding is Matillion is built for cloud data warehouses. It is not capable of working on on-premise DBs like SQL Server and perform actions on it. You can do it the other way around , update a Snowflake table based on changes in SQL Server table, but not in the direction you are hoping for.

3

Matillion calls this process of writing data to a SQL Server "Sync" or "Sync back". I have seen that they offer a training on their Academy now: https://academy.matillion.com/certifications/a135e194-9b14-11ed-9e2e-067360dfb065