Hi,
I have a pipeline where I have a copy data activity which queries a control table to copy data down from one of our on-premise servers into the Lakehouse we've created in Fabric. In this control table I specify the schema, table name, and the query I want to use to copy the data down. I've got the concept working, and on one of our on-premise servers I can do this successfully, when I try this from a different on-premise server when I run the pipeline instead of creating a table, it creates a schema based off the table name and then puts the delta files in an Unidentified folder along with the delta files...
I'm not finding much about why this is occurring on the web, is there a solution for this or has anyone else encountered this issue? I'm using just one table to try to figure this out with three rows of data, no special characters nothing odd about the table, I find it very weird it's just creating a new schema and not just writing a table under the dbo schema or putting the files in the unidentified folder under the dbo schema.
Any help would be appreciated.
