ALTER SPACE
You can route refresh jobs for all Reflections on datasets in a space to a specific engine. For more information, see Workload Management.
SyntaxALTER SPACE <space_name>
ROUTE REFLECTIONS TO { DEFAULT ENGINE | ENGINE { <engine_name> | <engine_uuid> } }
Parameters
<space_name> String
The name of the space where you want to route Reflection refresh jobs.
ROUTE REFLECTIONS TO { DEFAULT ENGINE | ENGINE { <engine_name> | <engine_uuid> } } String
Specify the engine on which to run jobs that create and refresh Reflections defined on datasets in the space. Use either the name or UUID of the engine. If neither a name nor a UUID is specified, the default engine is used. You can also directly specify the default engine.
Examples
Alter a space to route Reflections to the specified engineALTER SPACE "my_space"
ROUTE REFLECTIONS TO ENGINE "Engine 1";
ALTER SPACE "Space 3"
ROUTE REFLECTIONS TO DEFAULT ENGINE;