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! ðŸ˜Š

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.