How to change exisitng schema of a kql db table

[smpa01]

I have create a KQL db table with wrong schema for couple of columns. How can I update only those columns with correct schema.

I tried this on one column and i am getting an error

//query1 - does not work
.alter-merge table t1 ([PartitionId]:long)

//query2 - does not work
.alter-merge table t1 ([PartitionId]:long)

Both gives the following error
Admin command cannot be executed due to an invalid argument; argument: 'attributes', reason: 'Alter table does not support column data type change for existing columns (PartitionId). Current type=StringBuffer, requested type=I64'.

Thank you in advance

[Anonymous · Accepted solution]

Hi @smpa01 ,

You can use the .alter table update policy command to create update policies on tables in Real-Time Intelligence. When you trigger an update policy with a command that adds data to the source table, the data is also appended to the target table. The target table can have a different architecture than the source table.

For more details, please refer: Create a table update policy in Real-Time Intelligence - Microsoft Fabric | Microsoft Learn

Best Regards,

Neeko Tang

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