SET TAG

Specify the routing tag that will be used to route subsequent queries in the current session.

When a session routing tag is set, it is used to route queries according to the Workload Management (WLM) routing rules defined for that routing tag. If a ROUTING_TAG connection property is already set for the session, SET TAG will override it. The setting remains active until the session ends or until it is explicitly reset using RESET TAG. Changing the session routing tag does not persist across sessions.

Syntax

SET TAG <tag_name>

Parameters

<tag_name> String

Specifies the routing tag for all subsequent queries in the session. To use this routing tag, you should have a Workload Management (WLM) routing rule defined that routes queries based on the routing tag.

Examples

Create a WLM routing rule using a tag and set session with a routing tag

tag() = 'Dashboard'

SET TAG Dashboard;