Skip to content

Tables

ClickHouse tables in the pipeline. One page per table.

Status: Phase 2 placeholder

Detailed pages will be added in Phase 2.

Planned entries (priority order):

  • keywords.keywords_data_local — the central hub. 200 laksa shards × 256 ranges. Both raw input arrays (gsc_*_array_store, gt_*_array_store, gkp_*_array_store, js_*_store) and derived processed_* columns live here.
  • gsc.aggregated_keywords_global — GSC source-side aggregation read by kvprocessor.
  • keywords_volume.google_trends — GT raw data on isog.
  • keywords_volume.gkp_trends_raw — GKP raw data on isog.
  • keywords_volume.js_keywords_volume — JS raw data on laksa.
  • keywords.keywords_metrics_local — destination of stage-4 upload (internal analytics).
  • Snapshot tables — confidence_distribution_history, prediction_coverage_history.