analytics / priv /data_migrations /LocationsSync /sql /update-location-data-dictionary.sql.eex
Leon4gr45's picture
Upload folder using huggingface_hub (part 4)
c27e67a verified
Raw
History Blame Contribute Delete
318 Bytes
CREATE OR REPLACE DICTIONARY location_data_dict
<%= if @cluster? do %>ON CLUSTER '{cluster}'<% end %>
(
`type` String,
`id` String,
`name` String
)
PRIMARY KEY type, id
SOURCE(CLICKHOUSE(TABLE location_data <%= @dictionary_connection_params %>))
LIFETIME(0)
LAYOUT(complex_key_cache(size_in_cells 500000))