ALTER SPACE

Route refresh jobs for all reflections that are on datasets in a space to a specific queue. To use this functionality, enable this support key: planner.reflection_routing_inheritance_enabled. For more information, see Queue Routing.

Syntax

Syntax

ALTER SPACE <space_name>
  ROUTE REFLECTIONS TO { DEFAULT QUEUE | QUEUE { <queue_name> | <queue_uuid> } }

Parameters

<space_name> String

The name of the space where you want to route refresh jobs.

---

ROUTE REFLECTIONS TO { DEFAULT QUEUE | QUEUE { <queue_name> | <queue_uuid> } } String

Use the queue name or unique identifier to specify the queue on which to run jobs that create and refresh reflections that are defined on the dataset. If a queue name or unique identifier is not specified, the default queue is used. You can also directly specify the default queue.

Examples

Alter a space to route reflections to the specified queue

ALTER SPACE "mySpace"
  ROUTE REFLECTIONS TO QUEUE "Queue 1";

Alter a space to route reflections to the default queue

ALTER SPACE "Space 3"
  ROUTE REFLECTIONS TO DEFAULT QUEUE;