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.

How exelens connects to Amazon Redshift
Detailexelens on Amazon Redshift
Preferred sign-inCross-account IAM role for the Redshift Data API, protected by an External ID (a database password is the fallback)
What exelens can readSELECT on the views you import, through the exelens_reader database user
ComputeYour Serverless workgroup or provisioned cluster
Permissions on the roleredshift-data ExecuteStatement, DescribeStatement and GetStatementResult, plus GetClusterCredentials on that target
What you provideDatabase, region, workgroup or cluster ID, role ARN, External ID and database user
Where the data livesIn Redshift. Rows are loaded temporarily only while a question is answered

How it works on Redshift

  1. Create the database user. The setup script creates exelens_reader with SELECT on the views you choose.
  2. 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.
  3. Enter the target. Database, region and workgroup or cluster ID, plus the role ARN.
  4. 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.