Migrating Snowflake data to Fabric Datawarehouse

[NagaRK]

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?

1. 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.
2.  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,

[v-lgarikapat · Accepted solution]

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.

[NagaRK]

Thank you @v-lgarikapat 

[v-lgarikapat]

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.

[v-lgarikapat]

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

[v-lgarikapat]

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

[NagaRK]

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