Forum Discussion

eminalasmx's avatar
eminalasmx
Regular Visitor
6 months ago
Solved

Error with setup Query Snowflake-managed Apache Iceber tables by using Microsoft Fabric

I am following this article https://docs.snowflake.com/en/user-guide/tables-iceberg-query-using-microsoft-fabric After completing step 7, snowflake database is created in fabric but with 500 interna...
one lake
  • eminalasmx's avatar
    eminalasmx
    6 months ago

    hi v-dineshya 
    At the end, while waiting for Microsoft to assist, issue got solved itself(I suspect Microsoft fixed all the internal issues they had after going GA on 1st February)
    Now I have a working snowflake which is replicating apache tables to fabrics.
    I have a snowflake and fabric in same region.

    Thanks!

MJParikh's avatar
MJParikh
Super User
6 months ago

This looks like a Fabric service-side failure, not a Snowflake SQL error. The key clue is HttpStatus 500 with ErrorCode InternalError, plus a requestId and user sessionId in the dialog. In this flow, Fabric is calling Snowflake and building the Fabric-side database metadata. When Fabric cannot complete that backend call, the UI often shows 500 with no helpful client log.

First, check the region and geo alignment, as this has the highest hit rate.

  1. Region and geo alignment

  • Confirm your fabric capacity and workspace regions align with your tenant’s data residency.

  • Confirm your Snowflake cloud account and region are supported for this integration.

  • A mismatch often produces “database created,” but queries and object discovery fail with 500.

  1. Snowflake network access controls

  • If your Snowflake account has network policies, IP allowlists, or restrictive firewall rules, Fabric’s outbound traffic gets blocked, and the Fabric UI reports 500.

  • Quick test: temporarily relax the restriction or test from a Snowflake account without a network policy to isolate.

  1. Permissions and role used by the connection

  • Validate the role mapped in the Fabric connection has usage on the warehouse and database schema, plus access to the Iceberg objects and related catalog metadata.

  • Also confirm the warehouse is running and not suspended with tight auto-suspend settings during setup.

  1. Propagation delay and transient backend faults

  • Wait a few minutes, then refresh the item. I have seen the first metadata pull fail and succeed on the next attempt, especially during preview rollouts.

If it still fails, raise a Microsoft support ticket and share the requestId and user sessionId so engineering can trace the backend call.


Thank you!
Proud to be a Super User!
📩 Need more help?
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping

v-dineshya's avatar
v-dineshya
Community Support
6 months ago

Hi eminalasmx ,

Thank you for reaching out to the Microsoft Community Forum.

 

Hi MJParikh ,  Thank you for your prompt responses.

 

Hi eminalasmx , could you please try the proposed solution shared by MJParikh ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.

 

Regards,

Dinesh