These settings are autogenerated from source.
Enables or disables showing secrets in SHOW and SELECT queries for tables, databases,
table functions, and dictionaries.
User wishing to see secrets must also have
display_secrets_in_show_and_select server setting
turned on and a
displaySecretsInShowAndSelect privilege.
Possible values:
- 0 — Disabled.
- 1 — Enabled.
Controls whether the GeoJSON format enforces RFC 7946 geometry validity, in both directions.
When enabled (default), a geometry that violates the GeoJSON shape rules is rejected: a LineString (or a line of a MultiLineString) with fewer than two points; a Polygon or MultiPolygon ring with fewer than four points or whose first and last points differ (an unclosed ring); or an empty MultiLineString, Polygon, or MultiPolygon. This applies both when reading (such a document is rejected) and when writing (such a ClickHouse value is rejected instead of producing a document the input format would reject).
When disabled, these shape rules are not enforced: such geometries are read as-is and written as-is, so degenerate geometries round-trip, but a written document may not be valid GeoJSON.
The validation is structural only: it checks point counts and ring closure. It does not inspect the geometric correctness of a shape — ring orientation (the right-hand rule / winding order) is not enforced, and structurally valid but geometrically degenerate geometries are accepted, such as a zero-area polygon, a self-intersecting ring, or a polygon whose holes lie outside its outer ring. Non-finite coordinates (NaN, Inf) are always rejected regardless of this setting, because they cannot be represented as JSON numbers.
The name of column that will be used for storing/writing object names in JSONObjectEachRow format.
Column type should be String. If value is empty, default names row_{i}will be used for object names.
Use autogenerated Protobuf when format_schema is not set
Custom NULL representation in TSV format Last modified on July 22, 2026
