How to add a column to an eventhouse?

[FiFiF]

I am fairly new to Fabric and have a python script that sends data to an Eventstream, which in turn sends it into an Eventhouse.

Now I have changed the python script and am sending one column more than the Eventhouse stores, so I want to extend it by 1 column.

I have found this https://learn.microsoft.com/en-us/fabric/real-time-intelligence/table-update-policy but I do not know, how to use this code.

Can you tell me, how I would add a column named abc containing strings?

[datacoffee · Accepted solution]

Hi
You can alter a table directly and add a new column
The syntax is something like this

.alter table MyTable (ColumnX:string, ColumnY:int)

You can read the entire doc right here:
.alter table command - Kusto | Microsoft Learn

A different approach is to save the entire payload in one JSON column and then expand the coluimn in query time. The column datatype should then be dynamic datatype. You can easy unfold the JSON object using the "bag_unpack" command: 

https://learn.microsoft.com/en-us/kusto/query/bag-unpack-plugin?view=microsoft-fabric