RESET (Databricks SQL)

Resets Databricks SQL parameters at the session level to the global default values if they were changed using the SET command.


RESET [ parameter_key ]


  • parameter_key

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


-- Reset all parameters.

-- 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;


  • Configuration parameters
  • SET