Welcome to the Matillion Roadmap
Last updated: 06/09/2025
Check out our recently delivered features here
INSERT OVERWRITE instead of DELETE/INSERT in "Table Output" component with output mode TRUNCATE
Currently when using the 'Table Output' component with output mode 'Truncate' two seperate SQL statements (DELETE and INSERT) are created for Snowflake. This means that depending on the duration and successfull completion of the INSERT-statement the target table will be empty for some time.ย To have data available 24/7 is it an option to create a 'INSERT OVERWRITE' SQL statement instead or add it as an extra output mode? This will a create a single transaction within Snowflake with a combination of truncate and insert. As long as the INSERT is not completed successfully users will see the old data and afterwards the users will see the new data.
Subscribe to post
Get notified by email when there are changes.