I have a customer using Matillion ETL for Snowflake. They are considering a change to Redshift (possibly serverless) and want to know if their matillion jobs can be easily migrated from Matillion for Snowflake to Matillion. for Redhsift?
Hi @martin.redhead
I'd advise you to open a support ticket - email support@matillion.com for further assistance.
Thank you,
Chika
Hi @martin.redhead,
The answer to your question is going to completely depend on what's in the customers jobs. There are some components that will simply not convert at all because there is no equivalent on the Redshift side. This becomes especially true when the SQL Script component is used and DDL statements were executed. Some DDL statements will work the same on both sides but there are a ton that will not which will require the customer to rewrite the DDL statements to work with Redshift. Again it totally depends on the jobs themselves. Hopefully this helps.
Thanks Bryan. I really appreciate the detailed answer. I'll discuss the next steps with the customer to determine the effort required.
Cheers,
Martin