On page https://github.com/ClickHouse/pg_stat_ch/blob/main/docs/guides/clickhouse.md we provide a schema to apply to ClickHouse to use the pg_stat_ch extension:
For production, apply the schema directly to your ClickHouse instance:
clickhouse-client < docker/init/00-schema.sql
The schema file (docker/init/00-schema.sql) is the single source of truth. It creates:
The pg_stat_ch database
The events_raw table with all columns
Four materialized views for common analytics
However the schema file cannot be found, it returns 404.
On page https://github.com/ClickHouse/pg_stat_ch/blob/main/docs/guides/clickhouse.md we provide a schema to apply to ClickHouse to use the pg_stat_ch extension:
For production, apply the schema directly to your ClickHouse instance:
clickhouse-client < docker/init/00-schema.sql
The schema file (docker/init/00-schema.sql) is the single source of truth. It creates:
The pg_stat_ch database
The events_raw table with all columns
Four materialized views for common analytics
However the schema file cannot be found, it returns 404.