General¶

-- DADATA.mongo_dadata_address definition

CREATE TABLE DADATA.mongo_dadata_address
(
    `source` String,
    `result` String,
    `geo_lat` Float64,
    `geo_lon` Float64,
    `coordinates` String ALIAS [geo_lat, geo_lon],
    `country` String,
    `timezone` String,
    `region_with_type` String
)
ENGINE = MongoDB('10.55.55.5:27017',
                 'DaData',
                 'address',
                 'user',
                 'password');

-- skeleton.days definition

CREATE TABLE skeleton.days
(
    `Date` Date
)
ENGINE = ReplacingMergeTree
ORDER BY Date