Agent Skills: subquery-patterns-and-union

Use OPAL subquery syntax (@labels) and union operations to combine multiple datasets or time periods. Essential for period-over-period comparisons, multi-dataset analysis, and complex data transformations. Covers @label <- @ syntax, timeshift for temporal shifts, union for combining results, and any_not_null() for collapsing grouped data.

databaseID: rustomax/observe-community-mcp/subquery-patterns-and-union

Install this agent skill to your local

pnpm dlx add-skill https://github.com/rustomax/observe-community-mcp/subquery-patterns-and-union

Skill Files

Browse the full folder contents for subquery-patterns-and-union.

Download Skill

Loading file tree…

Select a file to preview its contents.