RESET

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Resets Databricks SQL parameters at the session level to the global default values if they were changed using the SET command. When using Databricks Runtime, parameters are known as SQL Conf properties.

Syntax

RESET [ parameter_key ]

Parameters

  • parameter_key

    Applies to: check marked yes Databricks SQL

    Optionally resets the value of the specified to the global default value. If you do not name a parameter all parameters are reset.

  • (none)

    Applies to: check marked yes Databricks Runtime

    Reset any runtime configurations specific to the current session which were set via the SET command to your default values.

Examples

-- Reset all parameters.
> RESET;

-- I, Databricks SQL if the default value of ansi_mode is true and you ran SET ansi_mode=false, the example below will restore it to 'true'.
> RESET ansi_mode;

–>