The following command fails. The /Files/pubs/authors folder contains a single parquet file. This is the authors table from the pubs database.
Please see documentation on how it should work, but does not.
But the "table load" command only works if there is an existing table. We can manually create one by right clicking on the parquet file.
We can make a manual call to the rest api to get it work.
{
"relativePath": "Files/pubs/authors/part-00000-657844e4-6b11-4bbb-bab1-68ead9a5cb7e-c000.snappy.parquet",
"pathType": "File",
"mode": "Overwrite",
"recursive": false,
"fileExtension": "parquet"
}
Make URL path using workspace, lakehouse and table name. Use the -i to leverage json file.
In short, the work around is to call the REST API. But, what I really want is the "table load" command to work.
Recent ideas
Improve Copy Job Validation Errors When Upsert Keys Are Missing
Improve Copy Job Validation Errors When Upsert Keys Are Missing Product: Microsoft Fabric Area: Data Factory – Copy Job Category: Error Handling / User Experience Problem When adding new tables ...jasonhorner5 hours agoRegular VisitorNew5Views0likes0Comments📉 How Would You Investigate a 20% Drop in Revenue?
A data analyst shouldn’t stop at identifying what happened. The real questions are: Where did the decline occur? → Why did it happen? → What caused it? → What should we do next? By analyzing regio...aliulmurtaza6 hours agoNew MemberNew6Views0likes0CommentsAdd “Don't show this again” option to Power Query Insert Step warning
When a transformation is performed while an earlier Applied Step is selected, Power Query displays the “Insert Step” warning every time. This is useful for new users, but becomes unnecessary for expe...bjs17469 hours agoNew MemberNew4Views0likes0Comments