How do I do multi-table inserts using METL for Snowflake?

Matillion ETL
1

Is there anyway to do this, It would really help me out! 😺

2

There are two approaches that can be used to carry out MTI within METL for Snowflake.

 

First we can simply drop the actual MTI SQL command into an orchestration SQL Script component and this will execute in exactly the same manner as the SQL would were it run in the Snowflake environment (such as through the browser or SnowSQL interfaces.

 

Alternatively, it is possible to break the overall outcome of the MTI command down to the individual actions and then build these using the components available within the transform jobs. For more information and examples on how to simulate the various MTI clauses refer to the Matillion blog on this topic at https://www.matillion.com/resources/blog/using-the-snowflake-multi-table-insert/

 

Thanks