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

Removes the workload for the current session, setting it to an empty string.

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;