topic Re: Write data into a shortcut to ADLSg2 in Data Engineering https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3826841#M1532 <P>Sure, I know it's not a copy, I was thinking in the possibility of using shortcut to write directly into ADLSg2.</P> Wed, 10 Apr 2024 10:41:00 GMT amaaiia 2024-04-10T10:41:00Z Write data into a shortcut to ADLSg2 https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3826779#M1530 <P>Is it possible to write data into a table stored in ADLSg2 referenced by shortcut? Or is it just for read-only operations?</P> Wed, 10 Apr 2024 10:16:46 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3826779#M1530 amaaiia 2024-04-10T10:16:46Z Re: Write data into a shortcut to ADLSg2 https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3826810#M1531 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/686932">@amaaiia</a>&nbsp;</P> <P data-sourcepos="1:1-1:148">No, shortcuts in Microsoft Fabric for ADLS Gen2 are for read-only operations. You cannot directly write data into a table referenced by a shortcut.</P> <P data-sourcepos="3:1-3:11">Here's why:</P> <UL data-sourcepos="5:1-7:0"> <LI data-sourcepos="5:1-5:92">Shortcuts are pointers to existing data locations. They don't create copies of the data.</LI> <LI data-sourcepos="6:1-7:0">Fabric uses the shortcut to access the original data in ADLS Gen2.<BR /><BR /></LI> </UL> <P>Hope this helps. Please let me know if you have any further questions.</P> Wed, 10 Apr 2024 10:26:30 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3826810#M1531 Anonymous 2024-04-10T10:26:30Z Re: Write data into a shortcut to ADLSg2 https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3826841#M1532 <P>Sure, I know it's not a copy, I was thinking in the possibility of using shortcut to write directly into ADLSg2.</P> Wed, 10 Apr 2024 10:41:00 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3826841#M1532 amaaiia 2024-04-10T10:41:00Z Re: Write data into a shortcut to ADLSg2 https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3827602#M1533 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/686932">@amaaiia</a>&nbsp;you are able to write to Delta tables stored in ADLSGen2 using a shortcut in a Fabric Lakehouse.&nbsp; In the attached image, I have a shortcut to an ADLSGen2 account with a Delta table.&nbsp; I can then read and write data to it.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AndyDDC_0-1712755060449.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1076042i5FBC2CDC3C590A34/image-size/large?v=v2&amp;px=999" role="button" title="AndyDDC_0-1712755060449.png" alt="AndyDDC_0-1712755060449.png" /></span></P><P>&nbsp;</P><P>You can also write Files too.</P><P>&nbsp;</P> Wed, 10 Apr 2024 13:18:36 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3827602#M1533 AndyDDC 2024-04-10T13:18:36Z Re: Write data into a shortcut to ADLSg2 https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3827614#M1534 <P>@Anonymous</a>&nbsp;shortcuts are not read only.&nbsp; Shortcuts also enable you to write back to the shortcut location.&nbsp; S3 and Google are not supported for write operations via Shortcuts, but ADLSGen2 is supported for write operations.</P> Wed, 10 Apr 2024 13:19:49 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3827614#M1534 AndyDDC 2024-04-10T13:19:49Z Re: Write data into a shortcut to ADLSg2 https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3827716#M1535 <P>Omg, that's what I tried before and it didn't work. now I've tried it again and it works...fantastic!</P> Wed, 10 Apr 2024 13:50:09 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3827716#M1535 amaaiia 2024-04-10T13:50:09Z Re: Write data into a shortcut to ADLSg2 https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3827740#M1536 <P>Thanks for clarifying <a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/265587">@AndyDDC</a>&nbsp;.&nbsp;</P> Wed, 10 Apr 2024 13:56:40 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3827740#M1536 Anonymous 2024-04-10T13:56:40Z Re: Write data into a shortcut to ADLSg2 https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3827981#M1537 <P>Glad to hear!</P> Wed, 10 Apr 2024 16:08:51 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/3827981#M1537 AndyDDC 2024-04-10T16:08:51Z Re: Write data into a shortcut to ADLSg2 https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/4343254#M5771 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/265587">@AndyDDC</a>&nbsp;are databricks unity catalog tables supported for write operations via shortcuts?</P> Thu, 26 Dec 2024 06:39:28 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Write-data-into-a-shortcut-to-ADLSg2/m-p/4343254#M5771 Uday2002 2024-12-26T06:39:28Z