No results when querying using Openrowset from ADLS Gen2.

Jeeva 161 Reputation points
2020-12-14T20:47:33.823+00:00

No results when querying using Openrowset from ADLS Gen2. I used to able to query earlier and for the past two weeks it is showing me No results. Any change in permissions?

I did follow all the permissions as in below URL.

https://learn.microsoft.com/en-us/azure/synapse-analytics/security/how-to-set-up-access-control?WT.mc_id=Portal-Microsoft_Azure_Synapse

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,330 questions
{count} votes

1 additional answer

Sort by: Most helpful
  1. Jeeva 161 Reputation points
    2020-12-15T13:46:05.567+00:00

    @PRADEEPCHEEKATLA-MSFT

    I was using OPENROWSET in Serverless. After few hours it started working with no change from my end. Does the Grants take few hours to materialize.

    1 person found this answer helpful.