Skip to content

Amazon Redshift

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud, designed for high-performance analysis using standard SQL queries. This Amazon Redshift application primarily centers around database management.

Before setting up

Before you can connect you need to make sure that:

  • You have an AWS root user account or IAM user created by root user for you.
  • You have an access key and secret generated for your IAM user.
  • You have access to models you want to use. You must request access to a model before you can use it. If you try to use the model before you have requested access to it, you receive an error.

Create IAM user

  • Go to Identity and Access Management.
  • Select Users from the left sidebar.
  • Click Create user.
  • Enter User name and click Next.
  • Select Attach policies directly option from Permissions options.
  • Add AdministratorAccess and AmazonRedshiftFullAccess policies, then click Next.
  • Review user details and permissions, then click Create user.

Generate access key

  • Go to Identity and Access Management.
  • Select Users from the left sidebar.
  • Select the user for whom you want to generate an access key.
  • Go to the Security credentials tab.
  • Scroll down to the Access keys section and click Create access key.
  • Select Use case and click Next.
  • Enter Description tag value and click Create access key.
  • Save Access key and Secret access key values to be able to connect to Amazon Redshift via Blackbird.

Connecting

  1. Navigate to apps and search for Amazon Redshift. If you cannot find Amazon Redshift then click Add App in the top right corner, select Amazon Redshift and add the app to your Blackbird environment.
  2. Click Add Connection.
  3. Name your connection for future reference e.g. ‘My organization’.
  4. Fill in the access key and secret obtained in the previous section.
  5. Click Connect.
  6. Confirm that the connection has appeared and the status is Connected.

Actions

Database

  • Get entries returns a list of table records based on the provided filters. You can optionally specify limit/offset or Where statement. Where statement is specified as a string, for example age > 18.

  • Add entry adds a new record to the table. Values are specified as an array of strings in the same order as the columns are inside of the table. You can specify less values if the rest of the columns are nullable or have a default value.

  • Update entries updates table records based on the provided filters. To define the criteria for updating, you can use a Where statement in a manner similar to the Get Entries action. The Columns and Values inputs must be of the same size, aligning with each other based on their respective positions.

    For instance, if the Columns input is: Name, Age, Gender; and the Values input is: Bob, 13, Non-binary; the table will update the record, setting Bob for Name, 13 for Age, and Non-binary for Gender. Ensure consistency in the size of the Columns and Values inputs for accurate and effective updates.

  • Delete entries deletes records from the specified table. To define the criteria for updating, you can use a Where statement in a manner similar to the Get Entries action.

  • Query database executes any raw SQL query and returns the results if there are any.

Feedback

Do you want to use this app or do you have feedback on our implementation? Reach out to us using the established channels or create an issue.