Lakehouse Table Schema setup after Eventstream

Hi bw_chec 

Please check this :

1. Do You Need to Create the Table Beforehand?
Yes, you need to either create the table beforehand or allow the Eventstream to create it dynamically. If you select an existing table as the destination, it must already exist in your Lakehouse. Alternatively, you can configure the Eventstream to create a new Delta table when setting up the destination.

2. Does the Table Need the Correct Schema?
Schema Enforcement: Microsoft Fabric enforces schema compatibility when writing data into a Lakehouse destination table. If you are using an existing table, its schema must match the incoming data from the Eventstream. Any discrepancies, such as missing or extra columns, may result in errors or data being written with NULL values for missing fields.

Dynamic Schema Creation: When creating a new Delta table via the Eventstream configuration, the schema is inferred from the first record of incoming data. All subsequent records are projected onto this schema.

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