Forum Discussion
Migrating Snowflake data to Fabric Datawarehouse
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,
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.
6 Replies
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.
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.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
Thank you v-lgarikapat
