How to copy data into a Lakehouse specifying table schema

[alfBI]

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

[spencer_sa]

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.

[alfBI · Accepted solution]

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