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