topic Re: Creating a shortcut in lakehouse in Data Engineering

Creating a shortcut in lakehouse

poojitha_yeluru — Mon, 06 May 2024 05:16:45 GMT

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 shown below , but when I load those files into table I am getting error as OneLakeShortcutAuthorizationFailed.

After clicking new table option

and I got below error
Onelake shortcut authorization failed. Make sure there are proper permissions and/or valid token for the storage linked by the shortcut.
activityId : 1893ef23-4eb9-4363-a37b-cbf5d7cec871
errorCode : OneLakeShortcutAuthorizationFailed
httpResponseCode : 403

Re: Creating a shortcut in lakehouse

v-cboorla-msft — Mon, 06 May 2024 08:08:58 GMT

Hi @poojitha_yeluru

Thank you for using Microsoft Fabric Community.

I tried to repro the scenario and didn't find any difficulty in loading the files into table. For reference please find the screenshot.

A 403 error while accessing ADLS Gen2 in Fabric Lakehouse after creating a shortcut with your credentials indicates an authorization issue. Could you pleaser refer the below links which might help you.

Link 1 : Solved: Fabric Lakehouse Shortcut to ADLS Gen2 Storage Not... - Microsoft Fabric Community

Link 2 : Solved: Not able to connect to ADLS with shortcut in Lakeh... - Microsoft Fabric Community

I hope this information helps. Please do let us know if you have any further queries.

Thank you.

Re: Creating a shortcut in lakehouse

poojitha_yeluru — Mon, 06 May 2024 08:39:49 GMT

Hi @v-cboorla-msft , Thanks for sharing the links , but after going to the above links I have given the role as storage blob reader and storage blob contributor as shown below. and also in networking part I have enabled the public network acces from all network. After doing above all it is giving me the same error.

Re: Creating a shortcut in lakehouse

v-cboorla-msft — Mon, 06 May 2024 08:42:00 GMT

Hi @poojitha_yeluru

Apologies for the inconvenience.

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

Re: Creating a shortcut in lakehouse

poojitha_yeluru — Mon, 06 May 2024 08:47:35 GMT

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

Re: Creating a shortcut in lakehouse

v-cboorla-msft — Mon, 06 May 2024 08:50:59 GMT

Hi @poojitha_yeluru

Glad that you query got resolved.
Please continue using Fabric Community for further queries.

Thanks.

Re: Creating a shortcut in lakehouse

poojitha_yeluru — Mon, 06 May 2024 09:17:44 GMT

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 .

Re: Creating a shortcut in lakehouse

v-cboorla-msft — Mon, 06 May 2024 09:23:00 GMT

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.

Re: Creating a shortcut in lakehouse

poojitha_yeluru — Mon, 06 May 2024 09:27:29 GMT

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