Connect to Query Editor v2

1. From Redshift console, click “Query data”
2. Select “Query editor v2”

Connect to Workgroup

In Query Editor v2:

1. Select Serverless workgroup: manhattan-redshift-workgroup
2. Database: dev
3. Authentication: Federated user (using IAM credentials)

Verify Connection

Run test query:

SELECT current_database();

Expected result: dev

Also run:

SELECT current_user();

Query Editor v2 uses temporary credentials to connect to the database via IAM.