WORKLOAD_ROUTING_RULES

Lists the routing rules that map workloads to a subcluster.

Lists the routing rules that map workloads to subclusters.

Column Name Data Type Description
OID INTEGER The object identifier for the routing rule.
WORKLOAD VARCHAR The name of the workload. When specified by a client (either as a connection property or as a session parameter with SET SESSION WORKLOAD), the client's queries are executed by the subcluster specified by the workload routing rule.
SUBCLUSTER_OID INTEGER The object identifier for the Subcluster.
SUBCLUSTER_NAME VARCHAR The subcluster that contains the Execution node that executes client queries for its associated workload.

Examples

The following query shows two rules that define the following behavior:

  • Clients with workload reporting are routed to subcluster default_subcluster.
  • Clients with workload analytics are randomly routed to sc_01 or sc_02.
=> SELECT * FROM v_catalog.workload_routing_rules;

        oid        | workload  |  subcluster_oid   |  subcluster_name
-------------------+-----------+-------------------+--------------------
 45035996273850122 | reporting | 45035996273704962 | default_subcluster
 45035996273849658 | analytics | 45035996273849568 | sc_01
 45035996273849658 | analytics | 45035996273849568 | sc_02

See also