Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Fabric storage url "alias" that matches blob storage url format

Hi, we recently tried to call fabric storage with a third party integration tool (BQ Omni) and got blocked because the tool only supports Blob storage urls, it will not take the slightly different fabric url format.   

 

BQ omni will only take this url format: https://<account>.blob.core.windows.net/<path>/<fileName
Fabric url format does not work: https://onelake.dfs.fabric.microsoft.com/<workspace>/<item>.<itemtype>/<path>/<fileName>

It appears this is a well known issue, documented at How do I connect to OneLake? - Microsoft Fabric | Microsoft Learn under Common Issues.

We've submitted a feature request to google already (BigQuery Omni OneLake External Table Support [413157431] - Issue Tracker)

However my question for Microsoft is:  rather than making every customer who hits it this send requests to fix in each individual third-party tool, could Microsoft not simply offer an alias for fabric urls that complies with the blob storage format and accepted by third party tools?   

E.g. could you provide an alias so for fabric path https://onelake.dfs.fabric.microsoft.com/<workspace>/<item>.<itemtype>/<path>/<fileName> the blob storage path https://fabric.blob.core.windows.net/<workspace>/<item> also works.  Or maybe https://fabric-workspace.blob.core.windows.net/<item>

Status: New
Comments
Mabasile_MSFT
Microsoft Employee

Hi! OneLake actually does support a Blob version of the FQDN, which you can use for any tools which specifically request the Blob endpoint (or when you want to use the Blob APIs): https://onelake.blob.fabric.microsoft.com

dedaimia
New Member
@Mabasile_MSFT thanks for the suggestion, but it's not the blob vs dfs in the url that BigQuery is objecting to. It's looking specifically for a url in a subdomain of blob.core.windows.net. e.g. https://[account].blob.core.windows.net. https://onelake.blob.fabric.microsoft.com is still a completely different domain. Request is could microsoft provide an alias for onelake storage that uses the blob.core.windows.net domain, so all third party connectors (including BigQuery) don't have to be updated to accept both domains.