K Suite Analytics Dev Console

Temporary local UI to build requests against the real query generator. It loads real domains and field values from ClickHouse for the current year, previews the generated SQL, executes the request through the API, and shows the result payload.

API/report
Preview/report/preview
Tablesloading
Sample Windowloading
Statusbooting

Request Builder

The console auto-loads available domains and sample field values from the real ClickHouse DB, limited to the current year so we stay lightweight while developing.
Loading domain suggestions...
Single click toggles a dimension. Selected dimensions automatically become `GROUP BY` fields.
Single click toggles a metric. No dimensions selected means a pure aggregate query without `GROUP BY`.

Query Shape

Waiting for schema...

Metric Notes

Additional Filters

`domain IN (...)` and `year = ...` are injected automatically. Use this section for extra conditions like `eventName`, `serviceProvider`, `date`, `month`, or nested ecommerce item fields.

Order By

Generated Request

Booting...

Execution View

SQL Preview

Waiting for preview...

Bound Parameters

[]

Response Data

Raw Response

Waiting for execution...

The UI is intentionally thin: every request still passes through the same validator, whitelist, query builder, and executor used by the API.

Documentazione Frontend

Questa sezione e pensata per Lovable e per chi costruisce l'interfaccia di gestione: contiene overview funzionale, specifica OpenAPI e accesso diretto alla Swagger UI generata dal backend.

Handbook

OpenAPI Preview

Loading OpenAPI spec...

Swagger UI

La Swagger UI e la vista tecnica endpoint-per-endpoint. L'overview a sinistra spiega invece come usare il sistema per builder, grafici e drill-down.