Forum Discussion

poojitha_yeluru's avatar
poojitha_yeluru
Icon for Advocate I rankAdvocate I
2 years ago
Solved

Creating a shortcut in lakehouse

I had created shortcut from my ADLS gen2 to fabric it works well , and I used the same  shortcut in lakehouse in files section get the data from  inputdataset container(contains two csv files) as sho...
data engineering
  • poojitha_yeluru's avatar
    poojitha_yeluru
    2 years ago

    After selecting the "load" option,  in the screenshot that you had given above the data was successfully transformed into tables.

poojitha_yeluru's avatar
poojitha_yeluru
Icon for Advocate I rankAdvocate I
2 years ago

Hi v-cboorla-msft , The query was not solved. I think that you did not get my query I will explain you in detailed manner.
I have created shortcut(ie.testing) using adls gen2 in files section (ie  lakehouse) .
Scenario 1:
I would like to convert all the files in that shortcut(ie testing) to tables . so I selected option load to tables as shown below

I will also provide the screenshot of files inside the testing shortcut.

After that I have selected the option load to files from the shortcut. I got the below error.

Scenario 2
In this case  when I load individual file from the shortcut ie circuit.csv it succesfully convert into table.
I dont know why it is showing error in first scenario . 

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi poojitha_yeluru 

 

Have you tried to load the another file i.e races.csv? Is it succesfully converted into table or facing any issue.

 

Thank you.

  • poojitha_yeluru's avatar
    poojitha_yeluru
    Icon for Advocate I rankAdvocate I
    2 years ago

    Hi v-cboorla-msft  the another file races.csv also be sucessfully loaded into tables, but my query is why It is giving me error when I select option load to tables in testing shortcut