Alter Session WLM Slots
    • Dark
      Light

    Alter Session WLM Slots

    • Dark
      Light

    Article Summary

    This article is specific to the following platforms - Redshift.

    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

    PropertySettingDescription
    NameTextA human-readable name for the component.
    Slot CountIntegerThe number of WLM slots to set for this session.

    What's Next