Overview

Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse used by organizations to store, query, and analyze large volumes of structured data using SQL.

Common uses for the Alchemer Amazon Redshift integration

• Personalize emails and workflow steps with information stored in Amazon Redshift
• Use Amazon Redshift data in workflow routing and decision logic
• Automate data retrieval and updates between Alchemer and Amazon Redshift
• Reduce manual data entry and downstream data processing
• Keep Amazon Redshift tables synchronized with Alchemer workflow activity
• Push workflow data into Redshift tables for analytics and reporting

What can the Alchemer Amazon Redshift integration do?

• Get data
• Update row
• Upsert row
• Push to table

You will need

• An AWS Access Key and Secret Key with permissions to access Amazon Redshift. More details in the authentication how-to guide.
• Your AWS Region where Amazon Redshift is deployed
• An Alchemer plan that includes integrations and the Integration Manager permission enabled.
  • Contact us if you are unsure if your plan includes integrations.

Setup Alchemer Amazon Redshift integration in workflow

Amazon Redshift | Get data

You will need:

• AWS credentials with access to Amazon Redshift. More details in the authentication how-to guide.
• Fields containing a unique identifier for the row

Configure the action

1. Open your workflow in Workflow builder.
2. Drag and drop the Redshift integration into your workflow.
3. Click the pencil icon to configure the action.
4. Select Redshift | Get data.
5. Redshift | Authentication: Select an existing authentication or create a new authentication.
6. Redshift | Choose workgroup: Select the Redshift workgroup you would like to use to write the queries.
7. Redshift | Choose database: Select the Redshift database you would like to use from the dropdown.
8. Redshift | Choose schema: Select the Redshift schema you would like to use from the dropdown.
9. Redshift | Choose table: Select the Redshift table you would like to use from the dropdown.
10. Redshift | Find row: Select the fields in this workflow that contain the values you want to use to find the specific row in Redshift.
11. Redshift | Get data back: Select the Redshift fields you want returned to the survey and then confirm. Only fields selected here will be returned to the workflow.
12. Save the action.

Status codes

• 200: A single row was successfully found
• 201:  Query ran successfully, but no rows were found
• 202: More than one row was found. The first row is used for the values returned to Alchemer
• 400: The external integration returned an error

Amazon Redshift | Update row

You will need:

• AWS credentials with access to Amazon Redshift. More details in the authentication how-to guide.
• Fields containing the row identifier

Configure the action

1. Open your workflow in Workflow builder.
2. Drag and drop the Redshift integration into your workflow.
3. Click the pencil icon to configure the action.
4. Select Redshift | Update row.
5. Redshift | Authentication: Select an existing authentication or create a new authentication.
6. Redshift | Choose workgroup: Select the Redshift workgroup you would like to use to write the queries.
7. Redshift | Choose database: Select the Redshift database you would like to use from the dropdown.
8. Redshift | Choose schema: Select the Redshift schema you would like to use from the dropdown.
9. Redshift | Choose table: Select the Redshift table you would like to use from the dropdown.
10. Redshift | Find row: Select the fields in this workflow that contain the values you want to use to find the specific row in Redshift. 
    • Note: All matching rows will be updated. Please ensure your selections and input data will identify the row(s) you want to update.
11. Redshift | Update row: Choose the survey data you want to use to update a row in your Redshift table.
12. Save the action.

Status codes

• 200: Successfully updated row
• 201: Query ran successfully. No rows updated
• 202: Multiple rows were found. X row(s) updated
• 400: The external integration returned an error

Amazon Redshift | Upsert row

You will need:

• AWS credentials with access to Amazon Redshift. More details in the authentication how-to guide.
• Fields containing the row identifier

Configure the action

1. Open your workflow in Workflow builder.
2. Drag and drop the Redshift integration into your workflow.
3. Click the pencil icon to configure the action.
4. Select Redshift | Upsert row.
5. Redshift | Authentication: Select an existing authentication or create a new authentication.
6. Redshift | Choose workgroup: Select the Redshift workgroup you would like to use to write the queries.
7. Redshift | Choose database: Select the Redshift database you would like to use from the dropdown.
8. Redshift | Choose schema: Select the Redshift schema you would like to use from the dropdown.
9. Redshift | Choose table: Select the Redshift table you would like to use from the dropdown.
10. Redshift | Find row: Select the fields in this workflow that contain the values you want to use to find the specific row in Redshift.
    • Note: All matching rows will be updated, please ensure that your lookup value is unique if you wish to update one row. If no matching rows are found a new row will be created.
11. Redshift | Upsert row in table: Choose the survey data you want to use to upsert a row in your Redshift table.
12. Save the action.

Status codes

• 200: Successfully inserted row
• 201: Query ran successfully. No rows updated
• 202: Successfully updated X row(s)
• 400: The external integration returned an error

Amazon Redshift | Push to table

You will need:

• AWS credentials with access to Amazon Redshift. More details in the authentication how-to guide.
• Target table in Amazon Redshift

Configure the action

1. Open your workflow in Workflow builder.
2. Drag and drop the Redshift integration into your workflow.
3. Click the pencil icon to configure the action.
4. Select Redshift | Push to table.
5. Redshift | Authentication: Select an existing authentication or create a new authentication.
6. Redshift | Choose workgroup: Select the Redshift workgroup you would like to use to write the queries.
7. Redshift | Choose database: Select the Redshift database you would like to use from the dropdown.
8. Redshift | Choose schema: Select the Redshift schema you would like to use from the dropdown.
9. Redshift | Choose table: Select the Redshift table you would like to use from the dropdown.
10. Redshift | Insert row into table: Choose the workflow data you want to use to insert a row into your Redshift table.
11. Save the action.

Status codes

• 200: Successfully inserted row
• 400: The external integration returned an error

Testing and Validation

How to test

• Trigger the workflow and monitor individual runs in the Monitor tab.
• Confirm the expected update or retrieval occurs in Amazon Redshift.
• Use metadata outputs for verification and debugging.

How to verify results

• Check the impacted rows or tables in Amazon Redshift.
• Ensure returned values match expectations.

Monitoring Integration Activity

Where to find logs

• Go to Results → Monitor.
• Select the Amazon Redshift integration step.

What logs display

• Input and output values
• Status codes
• Execution timestamps

Troubleshooting

Authentication issues

• Incorrect AWS Access Key or Secret Key
• Invalid AWS Region
• Insufficient IAM permissions

Lookup failures

• Invalid identifier values
• No matching rows found

Mapping errors

• Unsupported columns
• Incorrect data types

API errors

• SQL execution failures
• Endpoint or connectivity issues

FAQs