topic Re: Creating a new lakehouse table by a copy activity doesn't allow to add a dynamic content in Pipelines

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

pmscorca — Sun, 30 Jun 2024 18:09:39 GMT

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

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

frithjof_v — Sun, 30 Jun 2024 19:22:24 GMT

I am able to add dynamic content to table name.

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

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

pmscorca — Sun, 30 Jun 2024 19:58:55 GMT

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.

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

frithjof_v — Sun, 30 Jun 2024 20:17:47 GMT

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.

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

pmscorca — Sun, 30 Jun 2024 20:47:33 GMT

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?