Case insesitive data warehouse

Hi vasalari ,

You are correct in noting a current limitation in Microsoft Fabric: cross-database queries using three-part names (e.g., DbName.dbo.Table) are not supported in either Fabric SQL Database or Fabric Data Warehouse.

This limitation is due to the distributed architecture of these services, and is detailed in the official documentation here. While Fabric SQL Database supports case-insensitive collation (configurable via the REST API, as shown here), it still doesn’t allow querying across databases, which is crucial for your scenario involving frequent joins across multiple databases. On the other hand, Fabric Data Warehouse is case-sensitive by default and doesn't support cross-database queries.

Currently, there's no Fabric SQL engine that supports both features simultaneously. As a workaround, you might consider consolidating key tables into a single database or using a Lakehouse with shortcuts and views to aggregate data. We also suggest submitting your use case to the Fabric Ideas portal to inform future feature development.

I hope this gives you an idea, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.

Hi vasalari ,

Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum  we’ll be happy to assist.

Thank you, and please continue to use the Fabric Community Forum.