| CREATE TABLE IF NOT EXISTS location_data <%= if @cluster? do %>ON CLUSTER '{cluster}'<% end %> | |
| ( | |
| `type` LowCardinality(String), | |
| `id` String, | |
| `name` String | |
| ) | |
| <%= if @cluster? do %> | |
| ENGINE = ReplicatedMergeTree('/clickhouse/{cluster}/tables/{shard}/plausible_prod/location_data', '{replica}') | |
| <% else %> | |
| ENGINE = MergeTree() | |
| <% end %> | |
| ORDER BY (type, id) | |
| SETTINGS index_granularity = 128 <%= @table_settings %> | |