SET (Databricks SQL)

Sets a property, returns the value of an existing property or returns all SQL configuration properties with value and meaning.

Syntax 

SET

SET [ -v ]

SET property_key [ = property_value ]

Parameters

  • -v

    Outputs the key, value and meaning of existing SQL configuration properties.

  • property_key

    Returns the value of specified property key.

  • property_key = property_value

    Sets the value for a given property key. If an old value exists for a given property key, then it gets overridden by the new value.

Examples 

-- Set a property.
> SET spark.sql.variable.substitute=false;

-- List all SQL configuration properties with value and meaning.
> SET -v;

-- List all SQL configuration properties with value for current session.
> SET;

-- List the value of specified property key.
> SET spark.sql.variable.substitute;
key                           value
spark.sql.variable.substitute false