Forum Discussion
openrowset compatibility
Is OPENROWSET compatible with lakehouse files?
E.g. the following does not work
select *
from openrowset(
BULK 'https://onelake.dfs.fabric.microsoft.com/ws/lakehouse_testing.Lakehouse/File...
HI v-ssriganesh
Thanks for your reply, just want to give an update on the issue. The issue is not related to any syntax/URL issue, the feature rolled out by MSFT in phased manner. It was available only for few regions initially and not available regions like Central India and etc. and it was confirmed by MSFT. Now the feature is available in Central India region as well. Now I can able to query parquet files resides in onelake in sql end point using OPENROWSET. Thanks for your reply.
Hello BalajiL,
Thank you for your efforts and we're glad to hear your issue has been resolved. We appreciate you sharing your insights, as this will help other community members address similar issues more effectively.