Question 103744 in Azure Question posted in
The official documentation to get you started can be found here.

Azure – How to force an ADX to update from source with all historical data

Does anyone know a way to force a child table to update from the source table? it would be a one off command to run when the child table is created, then we have an auto update policy in place.

Googling suggests to try this, however it produces a syntax error

.update policy childTable with (sourceTable)

Thanks!:)

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    We had to use this:

    .append childTable <| updateFunction

  2. 0

    Update policy is a mechanism that works during the ingestion and does not support backfill.

    You can consider using materialized view with backfill property (if your transformation logic falls under the limitations) or create the child table based on a query, using the .set command.
    If your source table is huge you might need to split it to multiple commands.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search