Developer tools
Amazon Redshift integration for your workflows.
Connect Amazon Redshift to Collabase once and use 5 actions and 2 triggers in your workflows. No code needed, hosted in Switzerland.
Amazon Redshift in Collabase
Connect Amazon Redshift to Collabase once and use 5 actions and 2 triggers in your workflows. No code needed, hosted in Switzerland.
About the service
Fully managed cloud data warehouse from AWS.
How to connect it
- Open the integrations in the workspace settings.
- Choose Amazon Redshift and connect your account.
- Add a trigger or an action to the workflow.
- Open the Amazon Redshift console.
- Open your cluster (or Serverless → your workgroup) and copy the Endpoint. It looks like my-workgroup.123456789012.us-east-1.redshift-serverless.amazonaws.com:5439/dev: the part before : is the Host, the number is the Port and the part after / is the Database.
- Use the admin user, or a database user created with CREATE USER.
Amazon Redshift triggers
| Name | Description | Fields |
|---|---|---|
| New RowChecks at intervals | Triggers when a new row is added to a table. |
|
| New or Updated RowChecks at intervals | Triggers when a row is added or its timestamp column changes. |
|
Amazon Redshift actions
| Name | Description | Fields |
|---|---|---|
| Insert Rows | Inserts one or more rows into a table. |
|
| Update Rows | Updates every row where a column equals a value. |
|
| Delete Rows | Deletes every row where a column equals a value. |
|
| Find Rows | Finds rows where a column equals a value. |
|
| Run Query | Runs one SQL statement. |
|
Developer tools
Related integrations
Tools that often share a workflow.
Questions about Amazon Redshift
What can I automate with Amazon Redshift in Collabase?
Amazon Redshift brings 5 actions and 2 triggers, for example Insert Rows, Update Rows, Delete Rows, Find Rows and 1 more. You combine them in a workflow without code and mix them with every other integration.
How do I connect Amazon Redshift to Collabase?
You open the integrations in the workspace settings, choose Amazon Redshift and connect your account once, using custom credentials. After that all triggers and actions are available in the workflow.
Can Amazon Redshift start a workflow?
Yes. Amazon Redshift provides 2 triggers, for example New Row and New or Updated Row. The workflow runs as soon as the event happens.
Does the Amazon Redshift integration cost extra?
No. All integrations are included in every licence, in the Isolated Cloud and in Self-Hosted operation. There is no module price.
Test it against your own content. A proof of concept is ready within days.
We set up an instance with your content and you test it against real workflows. In a first conversation we clarify scope, operating model and timing.
