For Amazon Redshift
AI analytics for Amazon Redshift
Last updated
Short answer
exelens connects to Amazon Redshift through the Redshift Data API using a cross-account IAM role with an External ID, maps it to a read-only database user, reads only the views you import and answers in plain language on your own AI key.
| Detail | exelens on Amazon Redshift |
|---|---|
| Preferred sign-in | Cross-account IAM role for the Redshift Data API, protected by an External ID (a database password is the fallback) |
| What exelens can read | SELECT on the views you import, through the exelens_reader database user |
| Compute | Your Serverless workgroup or provisioned cluster |
| Permissions on the role | redshift-data ExecuteStatement, DescribeStatement and GetStatementResult, plus GetClusterCredentials on that target |
| What you provide | Database, region, workgroup or cluster ID, role ARN, External ID and database user |
| Where the data lives | In Redshift. Rows are loaded temporarily only while a question is answered |
How it works on Redshift
- Create the database user. The setup script creates
exelens_readerwithSELECTon the views you choose. - Create the IAM role. Trust the exelens AWS account and require the External ID the wizard gives you. Allow the Data API actions on your workgroup or cluster.
- Enter the target. Database, region and workgroup or cluster ID, plus the role ARN.
- Test, then import views. Pick the views people may ask about.
Why the External ID matters
An External ID prevents a third party from tricking exelens into assuming a role in your account. It is the standard AWS protection for cross-account access, and you can revoke the role at any time. Read about it in read-only access.
Book a demo and we will walk through the role with your AWS admin.
Frequently asked questions
- Why the Data API and not a direct connection?
- The Data API lets you grant access through IAM and an External ID, with nothing to open in a security group. A database user and password are available if you prefer them.
- Is Redshift Serverless supported?
- Yes. Enter the workgroup name. For provisioned clusters, enter the cluster identifier.
- Does exelens change anything in my cluster?
- No. The database user has SELECT on views only, and exelens warns if it finds write privileges.
See exelens on your Amazon Redshift
A short walkthrough with the founder: connect read-only, ask a real question, pin the answer.