Alter Session WLM Slots

Alter Session WLM Slots

This component allows users to alter the WLM (Workload Management) slots for a particular job run. Note that only components that run after 'Alter Session WLM Slots' will be affected by the change in slots.

The component works by altering the wlm_query_slot_count for the current session. For more information on Workload Management and slots, please refer to the Amazon Documentation. The default number of slots is always 1 if not using this component or otherwise manually altering the value.

Note that this affects queries on the Redshift server and so components such as data staging components ('query' components), that generally query an outside data source, will remain unaffected by the additional slots.

Properties