Use session properties #

A session property temporarily modifies the runtime environment for the duration of the current connection session to the cluster.

To modify the property, use the SET SESSION statement followed by the property name and a property-specific expression argument.

SET SESSION property_name = expression;

Session properties supported by a catalog can be set on a per-catalog basis for the current session. A catalog session property supported by more than one catalog can be set differently for each such catalog in the same session. To restrict a session property for use by a single property, prepend the catalog name to the property name:

SET SESSION catalog_name.property_name = expression;

Once set, session properties are in place only to the current connection session. You can have multiple connections to a cluster that each have a different combination of session properties. Once a session ends, either by disconnecting or creating a new session, any changes made to session properties during the previous session are lost.

Use the RESET SESSION statement to clear the current session back to Starburst Galaxy defaults. Use the SHOW SESSION statement to view all currently available session properties. For additional information, read about the SET SESSION statement.

Session properties for object storage table formats are described in Shared session properties.