topic How to copy data into a Lakehouse specifying table schema in Data Engineering

How to copy data into a Lakehouse specifying table schema

alfBI — Fri, 05 Dec 2025 11:46:29 GMT

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

Re: How to copy data into a Lakehouse specifying table schema

alfBI — Fri, 05 Dec 2025 12:00:17 GMT

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

Re: How to copy data into a Lakehouse specifying table schema

spencer_sa — Fri, 05 Dec 2025 20:52:17 GMT

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.