Skip to content
Data > Feed Handlers



  1. In order to set up the SQS feedhandler, unzip the tar.gz or zip file and copy the contents of the folder into the amione/lib directory.
  2. For generating AWS credentials, two methods are supported - (1) via STS, or (2) via Profiles.
    1. STS: Ensure that both ami.relay.fh.sqs.props.roleArn and ami.relay.fh.sqs.props.roleSessionName properties are set. If either is unset, the feed handler will default to using profiles. Ensure that you have a role with read access to the relevant AWS SQS queue. Note: this method will use your default credentials to assume the provided role (see AWS Default Credentials Provider) for more information on how this is acquired)
    2. Profiles: Ensure that you have a valid AWS credential tagged to a profile configured with read access to the relevant AWS SQS queue, see Step 2 of: AWS SQS Setting Up For configuring your profile for the first time, run aws configure sso and pass in the requested information to generate the required files and credentials for the SDK. Subsequently, running aws sso login --profile profilename will refresh your credentials.
  3. Add the respective properties to your file according to the section below

Message Format

This feedhandler accepts only valid JSON as an input source from SQS and expects it to be in a single map where each key represents a column on a table and its value a single column value.

Sample valid message:

  "colA": "colAValue",
  "colB": 123,

Note that by default, all column types are inferred to be Strings unless explicitly defined In the ami.relay.fh.sqs.props.tableMapping property using a colName=colType,... syntax.

Null values in the JSON message are skipped.

Valid types are as follows:

Underlying Column Type Valid Property Name (Case Insensitive)
String str, string
Integer int, integer
Short short
Long long
Float float
Double double
Character char, character
Boolean bool, boolean


# Required - use this to configure one or more FHs

# Required - used to start the FH

# Required - must match exactly

# Required - name of AMI table for data to be streamed into

# Optional - AWS profile name, uses default profile otherwise

# Optional - AWS profile file, uses default AWS location otherwise

# Optional - AWS role ARN

# Optional - AWS role session name

# Required - URL of the SQS Queue

# Required - AWS region of the SQS Queue

# Optional - If true, deletes read messages from the queue

# Optional - Specify column name and its underlying types, see Message Format section above for more info

# Optional - Number of messages to read at a time (defaults to 5)