These settings are available in system.settings and are autogenerated from source.
mysql_datatypes_support_level
Defines how MySQL types are converted to corresponding ClickHouse types. A comma separated list in any combination of decimal, datetime64, date2Date32, date2String or geometry. All modern mappings (decimal, datetime64, date2Date32, geometry) are enabled by default.
decimal: convert NUMERIC and DECIMAL types to Decimal when precision allows it.datetime64: convert DATETIME and TIMESTAMP types to DateTime64 instead of DateTime when precision is not 0.date2Date32: convert DATE to Date32 instead of Date. Takes precedence over date2String.date2String: convert DATE to String instead of Date. Overridden by datetime64.geometry: convert MySQL’s spatial types (LINESTRING, POLYGON, MULTILINESTRING, MULTIPOLYGON) to the corresponding ClickHouse geometric types, and the generic GEOMETRY type to the umbrella Geometry type. POINT is always converted to Point regardless of this option. Because a generic GEOMETRY column can hold any subtype, reading a value whose subtype has no ClickHouse counterpart (MULTIPOINT, GEOMETRYCOLLECTION) throws an exception at read time; columns declared as MULTIPOINT or GEOMETRYCOLLECTION map to String.
mysql_max_rows_to_insert
The maximum number of rows in MySQL batch insertion of the MySQL storage engine Last modified on July 22, 2026
