Access ADLS Gen2 files using R in Synapse notebooks

Question

Hi,
Is there a way to access/read ADLS Gen2 files from Synapse notebooks using R ( I'm trying this with my notebook's language set to SparkR(R) )

The error and R code snippet are as below

Error -
1 "Error in file(file, \"rt\"): cannot open the connection\n----LIVY_END_OF_ERROR----"
Warning message:
In file(file, "rt") :
cannot open file 'abfss://<container-name>@<my-adls-account>.dfs.core.windows.net/ingested/housingstock_vacant_dwellings.csv': No such file or directory

R Code snippet -
vacantDwellings <- read.csv("abfss://<my-container>@<my-adlsstorage-account>.dfs.core.windows.net/ingested/housingstock_vacant_dwellings.csv")

* However I can access the files when using Python as my notebook language with the snippet below*
import pandas as pd
input_data=pd.read_csv('abfss://<my-container>@<my-adlsstorage-account>.dfs.core.windows.net/ingested/housingstock_vacant_dwellings.csv')

Answer 1

Hello @Sunil V R ,

Thanks for the question and using MS Q&A platform.

You cannot directly call the ADLS Gen2 endpoint, you may checkout the detailed steps Operations on an Azure Data Lake Storage Gen2 endpoint and AzureStor: an R package for working with Azure storage.

Hope this helps.