SQL environment properties#

SQL environment properties allow you to globally configure parameters relevant to all SQL queries and the context they are processed in.

sql.forced-session-time-zone#

Force the time zone for any query processing to the configured value, and therefore override the time zone of the client. The time zone must be specified as a string such as UTC or other valid values.

sql.default-catalog#

Set the default catalog for all clients. Any default catalog configuration provided by a client overrides this default.

sql.default-schema#

Set the default schema for all clients. Must be set to a schema name that is valid for the default catalog. Any default schema configuration provided by a client overrides this default.

sql.default-function-catalog#

Set the default catalog for User-defined functions storage for all clients. The connector used in the catalog must support User-defined function management. Any usage of a fully qualified name for a UDF overrides this default.

The default catalog and schema for UDF storage must be configured together, and the resulting entry must be set as part of the path. For example, the following section for Config properties uses the functions schema in the brain catalog for UDF storage, and adds it as the only entry on the path:

sql.default-function-catalog=brain
sql.default-function-schema=default
sql.path=brain.default

sql.default-function-schema#

Set the default schema for UDF storage for all clients. Must be set to a schema name that is valid for the default function catalog. Any usage of a fully qualified name for a UDF overrides this default.

sql.path#

Define the default collection of paths to functions or table functions in specific catalogs and schemas. Paths are specified as catalog_name.schema_name. Multiple paths must be separated by commas. Find more details about the path in SET PATH.