Can a Kusto table have multiple update policy?

Question

I have a Kusto table and want to ingest data from two azure blob locations. Data from both sources need some transformation, hence I defined two update policies. So now I have two source tables and one destination table. The first update policy was working fine, and then I went on defining the second update policy which also worked fine. But after that when I observe, data was not getting ingested from the first source(It is present in the temporary source table) to the target table. I wonder if defining the second update policy somehow disabled the first update policy? Is it possible to have two update policies on one destination table?

Answer 1

Is it possible to have two update policies on one destination table?

Yes, it is possible.

You may want to verify that you have an array of 2 update policies defined on the target table, and that you didn't overwrite the first with the second using the .alter policy command.