Create Continuous Aggregate
Creates 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
| Property | Field | Description |
|---|---|---|
| Aggregate Query | inQuery | SELECT query with time_bucket for the aggregate. Must include time_bucket() and GROUP BY bucket |
| Client ID | inClientID | Client ID from Connect node |
| View Name | inViewName | Name for the continuous aggregate view |
Outputs
| Property | Field | Description |
|---|---|---|
| Success | outSuccess | Whether the continuous aggregate was created successfully |
Options
| Property | Field | Description |
|---|---|---|
| Credentials | optCredentials | TimescaleDB credentials (optional if using Connect node) |
| End Offset | optEndOffset | End of refresh window relative to now (e.g. 1 hour). Required if Refresh Interval is set |
| If Not Exists | optIfNotExists | Do not error if view already exists |
| Refresh Interval | optRefreshInterval | How often to refresh the aggregate (e.g. 1 hour，30 minutes). Leave empty for no automatic refresh policy |
| Start Offset | optStartOffset | Start of refresh window relative to now (e.g. 3 days). Required if Refresh Interval is set |
| Timeout (seconds) | optTimeout | Maximum time in seconds to wait |
Requirements
- A Client ID from this package's Connect node, unless you set credentials directly on this node.
Related nodes
Elsewhere in the package: Connect · Disconnect · Execute Query · Insert Data · Query Data · Create Hypertable · Drop Chunks · Enable Compression · Toolkit
See also
- TimescaleDB — every node in this package
- Message object — how properties read values from
msg - Handling failure — Continue On Error, Catch and retries