# Switch from Redshift to Snowflake
**URL:** https://matillioncommunity.discourse.group/t/switch-from-redshift-to-snowflake/1157
**Category:** Matillion ETL
**Created:** [July 20, 2020, 2:24am UTC](https://matillioncommunity.discourse.group/t/switch-from-redshift-to-snowflake/1157 "2020-07-20T02:24:48Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Yuki](https://matillioncommunity.discourse.group/u/Yuki)
#### Post date: [July 20, 2020, 2:24am UTC](https://matillioncommunity.discourse.group/t/switch-from-redshift-to-snowflake/1157/1 "2020-07-20T02:24:48Z")
Hi, there.
We are using Amazon Redshift, and Matillion ETL for Redshift, and planing to switch data warehouse Redshift to Snowflake.
I want to switch Matillion ETL for Redshift to Snowflake.
I don't want to rewrite matillion job.
Is there an easy way to migrate?
---
### Author:  [@Bryan](https://matillioncommunity.discourse.group/u/Bryan)
#### Post date: [July 20, 2020, 11:30pm UTC](https://matillioncommunity.discourse.group/t/switch-from-redshift-to-snowflake/1157/2 "2020-07-20T23:30:46Z")
That's a great question Yuki. I suspect it's a fairly complex answer because although the versions (Snowflake and Redshift) of Matillion are similar not all components area identical and therefore would like pose issues during a simple migration. Have you tried exporting from the Redshift instance and importing into the Snowflake instance of Matillion?
I could see how this may fail depending on the components used in the orchestrations. There are some components in the Redshift product that simply do not exist in the Snowflake product and vice versa.
If you have a Matillion rep, I would reach out and see if you can speak to a solutions architect. I don't know how much help this answer is but I hope it helped somewhat.
---
### Author:  [@ELTuser77](https://matillioncommunity.discourse.group/u/ELTuser77)
#### Post date: [July 22, 2020, 8:23am UTC](https://matillioncommunity.discourse.group/t/switch-from-redshift-to-snowflake/1157/3 "2020-07-22T08:23:53Z")
Hi [@Yuki](https://matillioncommunity.discourse.group/u/Yuki)
I am aware that Matillion have some capability to convert code between platforms so it may be worth reaching out to see if that is appropriate for your use case.
[@JoeCommunityManager](https://matillioncommunity.discourse.group/u/JoeCommunityManager) - can you get in touch with [@Yuki](https://matillioncommunity.discourse.group/u/Yuki) ?
Thanks!
---
### Author:  [@AB728514](https://matillioncommunity.discourse.group/u/AB728514)
#### Post date: [February 10, 2021, 11:14am UTC](https://matillioncommunity.discourse.group/t/switch-from-redshift-to-snowflake/1157/4 "2021-02-10T11:14:10Z")
Hello,
Good Evening Yuki,
Thank you for asking this question, I am very happy to answer :)
If you want to switch from Redshift to Snowflake, please go through this link: [https://community.snowflake.com/s/article/Migrating-from-Redshift-to-Snowflake](https://community.snowflake.com/s/article/Migrating-from-Redshift-to-Snowflake)
This link will guide you a lot and if anyone interested to do [Snowflake Online Certification](https://mindmajix.com/snowflake-training), please feel free to contact me.
Thanks & Regards,
Anita
---
### Author:  [@DataCat](https://matillioncommunity.discourse.group/u/DataCat)
#### Post date: [February 10, 2021, 6:34pm UTC](https://matillioncommunity.discourse.group/t/switch-from-redshift-to-snowflake/1157/5 "2021-02-10T18:34:37Z")
Hi,
One thing I have used before to migrate my DDL is [https://sqldbm.com](https://sqldbm.com) which got me thinking.
You could use the Matillon create table component and run the DDL and data at the same time, though personally, I would recommend managing the data model separately.
Though this may just be my need for control! 😅 Finally, you could then use Matillion to unload the data from Redshift to S3 and Load that into Snowflake.
Just an idea, but could answer your issue.
---
### Author:  [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)
#### Post date: [July 22, 2020, 12:55pm UTC](https://matillioncommunity.discourse.group/t/switch-from-redshift-to-snowflake/1157/6 "2020-07-22T12:55:52Z")
Thanks for the heads up [@ELTuser77](https://matillioncommunity.discourse.group/u/ELTuser77)
Hello [@Yuki](https://matillioncommunity.discourse.group/u/Yuki) and welcome to the community! This is something we can support you with, I would be more than happy to arrange for your account manager to contact you with regards to this if you would like?
Thanks again, Joe 😀
---
### Author:  [@Yuki](https://matillioncommunity.discourse.group/u/Yuki)
#### Post date: [July 27, 2020, 1:45am UTC](https://matillioncommunity.discourse.group/t/switch-from-redshift-to-snowflake/1157/7 "2020-07-27T01:45:56Z")
Hello Joe and thank you for quick response!
It is still under consideration.
I will contact account manager as we make progress.
---
### Author:  [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)
#### Post date: [July 27, 2020, 7:43am UTC](https://matillioncommunity.discourse.group/t/switch-from-redshift-to-snowflake/1157/8 "2020-07-27T07:43:14Z")
You are welcome [@Yuki](https://matillioncommunity.discourse.group/u/Yuki)
Keep me posted and I can be on hand to assist you with this 👍
Kind regards, Joe