search

microsoft / delta-kusto

Engine able to compute delta between ADX clusters (and/or Kusto scripts) and generate update scripts
MIT License
46 stars 18 forks source link

Partitioning policy is not created for new table from the script. #162

Closed matipos2 closed 5 months ago

matipos2 commented 5 months ago

Situation New empty database. Set of kql scripts is prepared to create and manage complete database. For example: create-merge, policy update, policy sharding, policy partitioning, etc. delta-kusto is configured to read all the scripts and compare, deploy it to actual database.

Expected result Everything (the state of the database) should be merged into Azure Data Explorer.

Actual result Merge with delta-kusto correctly introduced all changes except one: partitioning policy. No errors, simply, the partitioning policy is omitted.

The partitioning policy command was not found neither in the commands going to be executed, printed by delta-kusto nor in the database after deployment.

matipos2 commented 5 months ago

Found root cause. The issue is not correlated to delta-kusto, but to the scripts. The scripts had syntax error, so the delta-kusto couldn't recognize it as a valid kql script, so it has been omitted. After fixing the script, partitioning policy is recognized properly from the scripts.