USQL Datalake Question

Question

Is there anyway to backup the partition files of usql table? Or the only way is to import the data to csv file.

Answer 1

@DSM
I created a table with partitions by using these examples with Data Lake Analytics in the portal.

Then in the portal I used the Data Explorer to locate and download the partition files. They are located under:
Root > Catalog > Database > {UID} > Schema > {UID} > Table > {UID}

The UID's are not easy to read, but I did find a correlation.

When I looked up the details of the query run which inserted the data , I found the corresponding file location.
Specifically,
Root > System > Jobservice > Jobs > USQL > {year} > {month} > {day} >{UID} > SystemInternalInfo.xml
Then I searched for "write", and found the filepath it wrote to.
The path starts with
adl://{name}.azuredatalakestore.net/catalog/...