SET SESSION WORKLOAD

Sets the workload for the current session.

For details on this and other session parameters, see SHOW:

Syntax

SET SESSION WORKLOAD TO { workload_name | DEFAULT | NONE }

Parameters

workload_name

The workload to use for the current session. The specified workload must be associated with a workload routing rule.

DEFAULT

Sets the workload to the workload granted to the current user or their roles. If they have more than one workload, the one with the highest priority is used.

NONE

Removes the workload for the current session.

Privileges

None

Examples

The following example sets analytics as the workload for the current session:

=> CREATE ROUTING RULE analytic_rule ROUTE WORKLOAD analytics TO SUBCLUSTER my_subcluster;
=> SET SESSION WORKLOAD analytics;