Connect to Amazon Redshift

Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshiftv2/.

We recommend using the administrative user created in Create an administrative user for managing AWS resources.

Create a Redshift Serverless data warehouse or a provisiond cluster. For more information, see Creating a data warehouse with Redshift Serverless or Creating a cluster in the Amazon Redshift User Guide.

Once provisioning is complete, choose Query Data to open the query editor. Connect to your database.

Change the following settings:

Create your data tables under the public schema. INSERT any initial data into these tables.

Run the following commands in query editor:

CREATE USER "IAMR:AppBuilderDataAccessRole" WITH PASSWORD DISABLE;

GRANT ALL ON ALL TABLES IN SCHEMA public to "IAMR:AppBuilderDataAccessRole";

Sign in to the IAM console with a user that has permissions to create IAM roles. We recommend using the administrative user created in Create an administrative user for managing AWS resources.

In the navigation pane of the console, choose Roles and then choose Create role.

In Trusted entity type, choose Custom trust policy.

Replace the default policy with the following policy to allow App Studio applications to assume this role in your account.

You must replace 111122223333 with the AWS account number of the account used to set up the App Studio instance.

{ 
    "Version": "2012-10-17",
    "Statement": [
        { 
            "Effect": "Allow",
            "Principal": { 
                "AWS": "arn:aws:iam::111122223333:root"
            }, 
            "Action": "sts:AssumeRole",
            "Condition": {
                "StringEquals": {
                        "aws:PrincipalTag/IsAppStudioAccessRole": "true"
                }
            }
        } 
    ]
}

Choose Next.

In Add permissions, search for and select the policies that grant the appropriate permissions for the role. Choosing the + next to a policy will expand the policy to show the permissions granted by it and choosing the checkbox selects the policy..

For Amazon Redshift, you may consider adding the following policies:

For more information about using IAM policies with Amazon Redshift, including a list of managed policies and their descriptions, see Using identity-based policies (IAM policies) for Amazon Redshift in the Amazon Redshift Management Guide.

Choose Next.

In Role details, provide a name and description.

In Step 3: Add tags, choose Add new tag to add the following tag to provide App Studio access:

Choose Create role and make note of the generated Amazon Resource Name (ARN), you will need it when creating the Amazon Redshift connector in App Studio.

Navigate to App Studio.

In the left-side navigation pane, choose Connectors in the Manage section. You will be taken to a page displaying a list of existing connectors with some details about each.

Choose + Create connector.

Choose the Amazon Redshift connector.

Configure your connector by filling out the following fields:

Choose Next. Review the connection information and choose Create.

The newly created connector will appear in the connectors list.