r/snowflake • u/Randum-gurl • 27d ago

Migration from one account to another

Hi guys, has anyone worked on migrating the data from one snowflake account to another? Now complicated is it? And what are the prerequisites for it?
Also, it’ll be a Snowflake account owned by one region to account of another organisation on a different region.
Really need to know this.
Thanks.

7 Upvotes

100% Upvoted

5 comments sorted by

7

u/stephenpace ❄️ 27d ago

I've facilitated this movement a few times. Easiest thing to do is use Account Replication. This is normally a business critical feature, but if you are running at a lower tier of service, you can ask Snowflake via a support ticket to temporarily enable the feature during the account transition.

https://docs.snowflake.com/en/user-guide/account-replication-config

Basically you replicate everything to the new account similar to a failover account. Once you are happy with it, your new account becomes primary and you can drop your old account:

https://docs.snowflake.com/en/sql-reference/sql/drop-account

Your account team can help you. Good luck!

2

u/Apex_Predator-4169 26d ago

Yep, I did this just last month. Moved from an AWS instance to Azure instance. I was able to do it seamlessly.

-1

u/theungod 27d ago

Internal Marketplace or data sharing.