Forum Discussion

asankab's avatar
asankab
Icon for Helper I rankHelper I
2 years ago
Solved

Error when reading a ADLSGen2 csv from a synapse notebook while the private endpoint is enabled

Hi, With a SASS token i was able to read the data from the notebook (when the network access of the storage account is public) interactive mode. Also, i was able to read the data via a pipeline co...
data engineering
data warehouse
Real-time Analytics
security
  • asankab's avatar
    asankab
    2 years ago

    Thanks for the hint v-gchenna-msft!

     

    Was able to find and fix the issue, the problem was with the path. Now its working! ðŸ˜Š

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi asankab ,

Thanks for using Fabric Community.
Can you please share the screenshot of the issue along with the code?
Do you have proper access to it? and did you cross checked the abfs path?

If you can provide these details, I would be able to guide you better.

  • asankab's avatar
    asankab
    Icon for Helper I rankHelper I
    2 years ago

    Here is the code, I am using to read the .csv

     

    file_path = "abfss://[email protected]/data/sales.csv"
    df = spark.read.csv(file_path, header=True, inferSchema=True)
    df.show(5)
    • asankab's avatar
      asankab
      Icon for Helper I rankHelper I
      2 years ago

      Thanks for the hint v-gchenna-msft!

       

      Was able to find and fix the issue, the problem was with the path. Now its working! ðŸ˜Š

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi asankab ,

        Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.