appendcols - Amazon CloudWatch Logs
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

appendcols

Use the appendcols command to append a sub-query's columns to the current results by positional row matching.

Syntax

| appendcols [override=true|false] [max=n] ( subquery )

The command uses the following arguments:

  • override (Optional) – Whether to overwrite existing fields. Default: false.

  • max (Optional) – Maximum rows to process (1–100000, default 10000).

  • subquery – A complete CloudWatch Logs Insights query enclosed in parentheses.

Example

The following query appends average latency per service from another log group.

fields svc
| stats count(*) as cnt by svc
| appendcols override=true ( SOURCE lg | stats avg(latency) as avgLat by svc )