Forum Discussion

amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago
Solved

Write data into a shortcut to ADLSg2

Is it possible to write data into a table stored in ADLSg2 referenced by shortcut? Or is it just for read-only operations?
data engineering
  • AndyDDC's avatar
    AndyDDC
    2 years ago

    Hi amaaiia you are able to write to Delta tables stored in ADLSGen2 using a shortcut in a Fabric Lakehouse.  In the attached image, I have a shortcut to an ADLSGen2 account with a Delta table.  I can then read and write data to it.

     

     

    You can also write Files too.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi amaaiia 

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.

Here's why:

  • Shortcuts are pointers to existing data locations. They don't create copies of the data.
  • Fabric uses the shortcut to access the original data in ADLS Gen2.

Hope this helps. Please let me know if you have any further questions.

amaaiia's avatar
amaaiia
Skilled Sharer
2 years ago

Sure, I know it's not a copy, I was thinking in the possibility of using shortcut to write directly into ADLSg2.