Forum Discussion
How to copy data into a Lakehouse specifying table schema
Hi,
I am trying to copy a table into a Lakehouse but I have no way to specify the schema name
In the old data copya field wxisted to place the name of the schema
but in the new copy data this field does not exist..
I have tried to place the schema in the name as follows
Schema.Table
but then it creates a table in the dbo schema with the Schema.Table name
How to avoid that?
Thanks,
Alfons
Well, believe me or not I have just found the solution (or at least a workaround) to what to seems to be a bug in the more stupid way. I have saved the pipeline (save as) to create a copy of it and when I opened it,
Surprise!
The schema option has appeared 🙂
Just in case it helps you alkready know.
Alfons
2 Replies
Well, believe me or not I have just found the solution (or at least a workaround) to what to seems to be a bug in the more stupid way. I have saved the pipeline (save as) to create a copy of it and when I opened it,
Surprise!
The schema option has appeared 🙂
Just in case it helps you alkready know.
Alfons
Given that you're using parameters to drive the connection including the lakehouse, it's possible took a short while to look up the lakehouse based on the value in the parameter, discover it was schema enabled, and change the UI to the schema enabled one.
The UI does depend on the lakehouse type.
