topic Migrating Snowflake data to Fabric Datawarehouse in Data Warehouse

Migrating Snowflake data to Fabric Datawarehouse

NagaRK — Wed, 28 May 2025 07:15:39 GMT

Hi Team,

I would like to migrate around 15TB of SQL Tables data from the Snowflake to Fabric. Its one time activity. I have below questions. Could you please help me with below questions?

We have 2 options to migrate . What is the best option?
- Option1:Mirroring the warehouse , once mirrored then deleting it and then copying the data to finalwarehouse for write access.
- Option2: using Data factory copy activity.
Do we need to use data gateway in my connection for migrating 15TB of data, my snowflake is accessible for Fabric. do we still need Data gateway? When should we go for Data gateway?

Thanks,

Re: Migrating Snowflake data to Fabric Datawarehouse

v-lgarikapat — Wed, 28 May 2025 15:44:46 GMT

Hi NagaRK ,

Option 1 is great for near real-time reporting use cases, not bulk loads.

Option 2 (Data Factory) is the right tool for large, one-time migrations like yours.

Do You Need a Data Gateway?

Answer:
If your Snowflake instance is accessible over the public internet (i.e., Fabric can reach it directly), you do NOT need a data gateway.

You DON'T need a gateway if:

Your Snowflake endpoint is public (like xyz.snowflakecomputing.com)
You can connect to it from within Microsoft Fabric without any VPN or firewall restrictions

You DO need a gateway if:

Snowflake is behind a corporate firewall
It's hosted in a private network or VNet that Fabric cannot access directly
Configure Snowflake in a copy activity - Microsoft Fabric | Microsoft Learn
How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn
Microsoft Fabric Mirrored Databases From Snowflake - Microsoft Fabric | Microsoft Learn

If this post helped resolve your issue, please consider giving it Kudos and marking it as the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana.

Re: Migrating Snowflake data to Fabric Datawarehouse

v-lgarikapat — Mon, 02 Jun 2025 07:18:44 GMT

Hi NagaRK ,

If your issue has been resolved, please consider marking the most helpful reply as the accepted solution. This helps other community members who may encounter the same issue to find answers more efficiently.

If you're still facing challenges, feel free to let us know we’ll be glad to assist you further.

Looking forward to your response.

Best regards,
LakshmiNarayana.

Re: Migrating Snowflake data to Fabric Datawarehouse

v-lgarikapat — Thu, 05 Jun 2025 04:47:05 GMT

Hi NagaRK ,

If your question has been answered, kindly mark the appropriate response as the Accepted Solution. This small step goes a long way in helping others with similar issues.

We appreciate your collaboration and support!

Best regards,
LakshmiNarayana

Re: Migrating Snowflake data to Fabric Datawarehouse

v-lgarikapat — Mon, 09 Jun 2025 04:57:01 GMT

Hi NagaRK ,

As we haven't heard back from you, we are closing this thread. If you are still experiencing the same issue, we kindly request you to create a new thread we’ll be happy to assist you further.

Thank you for your patience and support.

If our response was helpful, please mark it as Accepted as Solution and consider giving a Kudos. Feel free to reach out if you need any further assistance.

Best Regards,

Lakshmi Narayana

Re: Migrating Snowflake data to Fabric Datawarehouse

NagaRK — Fri, 13 Jun 2025 10:07:24 GMT

Thank you v-lgarikapat

Re: Migrating Snowflake data to Fabric Datawarehouse

NagaRK — Fri, 13 Jun 2025 10:08:11 GMT

Sorry I was not available. Thanks for the marking as solution. That works for me.