Skip to main content

Refresh Continuous Aggregate

Refreshes a continuous aggregate in TimescaleDB.

This node is also exposed as an AI Agent tool.

This node has 1 input port and 1 output port.

Common Properties​

Every node shares these.

  • Name — the node's display name on the canvas.
  • Color — the node's colour on the canvas.
  • Delay Before (sec) — wait this long before the node runs.
  • Delay After (sec) — wait this long after the node runs.
  • Continue On Error — carry on instead of failing the flow. Defaults to false.
info

When Continue On Error is true the error is not raised at all, so a Catch node will not see it either.

Inputs​

PropertyFieldDescription
Client IDinClientIDClient ID from Connect node
End TimeinEndTimeEnd of the refresh window as an interval from now (e.g. 1 hour) or a timestamp
Start TimeinStartTimeStart of the refresh window as an interval from now (e.g. 7 days) or a timestamp
View NameinViewNameName of the continuous aggregate view to refresh

Outputs​

PropertyFieldDescription
SuccessoutSuccessWhether the refresh completed successfully

Options​

PropertyFieldDescription
CredentialsoptCredentialsTimescaleDB credentials (optional if using Connect node)
Timeout (seconds)optTimeoutMaximum time in seconds to wait (refresh can be slow for large windows)

Requirements​

  • A Client ID from this package's Connect node, unless you set credentials directly on this node.

Create Continuous Aggregate

Elsewhere in the package: Connect · Disconnect · Execute Query · Insert Data · Query Data · Create Hypertable · Drop Chunks · Enable Compression · Toolkit

See also​