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!:)

CodePudding user response：

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.

CodePudding user response：

We had to use this:

.append childTable <| updateFunction