Welcome to the Matillion Roadmap
Last updated: 05/05/2025
Check out our recently delivered features here.
"Rewrite Table" component in Snowflake using CREATE OR REPLACE
Currently when you look at the SQL behind the “Rewrite Table” component in Snowflake, it performs first a “DROP TABLE IF EXISTS” command and then a “CREATE TABLE” command. It would be cleaner for this to simply leverage the “CREATE OR REPLACE” command, as you can then combine this with the “COPY GRANTS” option to avoid permissions being dropped on an object accidentally. It also avoids dropping the table if the new CREATE statement fails for whatever reason…
Post Information
Subscribe to post
Get notified by email when there are changes.
Upvoters
+37
Downvoters
Post Details