SQS Message
    • Dark
      Light

    SQS Message

    • Dark
      Light

    Article Summary

    This article is specific to the following platforms - Snowflake - Redshift.


    SQS Message Component

    Snowflake users: this feature is only available for instances hosted on AWS.

    Post a message to an Amazon Simple Queue Service (SQS) queue. Other applications can read those messages and perform further processing. FIFO Queues can be used through this component where available.

    The AWS API for SQS list queues has a hard limit of 1000, meaning the retrieval of queue names is limited to the first 1000 that are defined. However, users can add additional queues, which will still validate and function, provided the user enters the queues manually.

    Properties

    PropertySettingDescription
    NameStringA human-readable name for the component.
    RegionSelectThe AWS region that the queue is located in. This must be an existing SQS queue. The default value is the region that Matillion ETL is running in.
    Queue NameSelectThe name of the queue to write to. Available queues for the selected region are listed.
    MessageTextThe message to post to the designated queue. This can contain variables to be resolved at runtime, in the same way that other components can use variables - see Using Variables for more details.
    Message formatSelectMessages may be optionally Base64 encoded, or compressed with 'gzip' compression. (If compression is chosen, then the compressed data is also Base64 encoded, so it can be transported as plain text.)
    Message Group IDTextVisible only when the above properties specify a valid First-In-First-Out (FIFO) Queue. The tag that specifies that a message belongs to a specific message group. For more information on FIFO queues, including regional availability, see the Amazon Documentation.
    Message Duplication IDTextVisible only when the above properties specify a valid First-In-First-Out (FIFO) Queue. The token used for deduplication of sent messages. For more information on FIFO queues, including regional availability, see the Amazon Documentation.

    What's Next