topic When writing to a lakehouse target table using Dataflow Gen2, how can I specify the schema in Dataflow

When writing to a lakehouse target table using Dataflow Gen2, how can I specify the schema

WithwindOK — Thu, 06 Mar 2025 00:54:48 GMT

When writing to a lakehouse target table using Dataflow Gen2, how can I specify the schema.When the table name contains the character '.', an error will occur.

Re: When writing to a lakehouse target table using Dataflow Gen2, how can I specify the schema

Anonymous — Thu, 06 Mar 2025 01:11:33 GMT

Hi WithwindOK

The error message indicates that the table name contains invalid characters, specifically a period (.), which is not allowed. When writing to a Lakehouse target table using Dataflow Gen2 in Microsoft Fabric, you can follow these steps to resolve this issue:

Make sure that the table name contains only valid characters: letters, numbers, underscores (_), and cannot end with a space.

If you need to include a schema (such as ShangWuUser), define the schema separately in the Dataflow Gen2 settings instead of embedding the schema name directly into the table name.

About specifying the target schema in Dataflow Gen2:

In the target settings of Dataflow Gen2, you can select an existing table or create a new table. If the target table supports schemas, you can specify the schema when connecting.

If the table name contains invalid characters (such as .), the system automatically adjusts the table name to conform to the naming rules of the target.

Please refer to the following links:

Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: When writing to a lakehouse target table using Dataflow Gen2, how can I specify the schema

WithwindOK — Thu, 06 Mar 2025 02:00:59 GMT

Hi Anonymous

Excuse me,Where can I choose or set the schema (such as ShangWuUser)? I didn't see it in the wizard, and it wasn't mentioned in the linked documentation.Would you give me a screenshot of the schema.Thanks.

Re: When writing to a lakehouse target table using Dataflow Gen2, how can I specify the schema

Anonymous — Thu, 06 Mar 2025 03:27:38 GMT

Hi WithwindOK

Update to the above link:

Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn

By default, it is placed in the dbo schema. You can drag and drop it into the target schema.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.