07 · Tables A→ZG · Read & explore
Aggregate & summarize
Count, sum, average, and group with the aggregate tool - no SQL required.
aggregate computes COUNT / SUM / AVG / MIN / MAX with optional grouping and
filtering - without writing SQL. Use it when query_rows
isn't enough but you don't need a full SQL query.
Aggregate
{
"table": "eddytor.cfg_xxx.<uuid>_products",
"aggregations": ["COUNT(*)", "AVG(price)"],
"group_by": ["category"],
"filter": "status != 'deleted'"
}Returns one row per group with the requested aggregates. The filter uses the
same SQL WHERE syntax as query_rows.
Scope
Heads up
aggregate operates on rows within one table - it can't
aggregate across tables or count tables. To count tables use
list_tables; for cross-table work use
execute_sql with a join.Identifying domain candidates
A handy use: check distinct counts to find
domain candidates - a low-cardinality string
column is a good one to lock down. profile_table does
this too.