Creating a new lakehouse table by a copy activity doesn't allow to add a dynamic content

[pmscorca]

Hi,

I'm using a copy activity to consider some csv files in order to save the related data as a lakehouse table. The tables don't exist in the destination lakehouse. F.e. I'd like to get a customer.csv file and copy it as customer lakehouse table.

The copy activity allows to create a new lakehouse table, but I cannot pass the table name as a dynamic content.

I cannot believe it!

Any helps to me in order to create a new table in a dynamic manner using a copy activity? Thanks

[frithjof_v · Accepted solution]

I am able to add dynamic content to table name.

Which dynamic content do you want to add as table name?

[pmscorca]

Hi, you are showing the case when the table already exists.

I'm referring when the table doesn't exist and it occurs to create it.

[frithjof_v]

I am creating a new table.

But I am not using dynamic content for the Lakehouse connection. I am only using dynamic content for the table name.

If I use dynamic content for the Lakehouse connection also, I get the same issue as you.

[pmscorca]

Previously I had to use the New table option to create a new table with the copy activity, but now it seems that isn't necessary.

I've specified the dynamic content for the table name and I can create a new table choosing append or overwrite table action.

Perhaps has been data factory updated recently?