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