Use Amazon Redshift in your Crisp app.
Run SQL on an Amazon Redshift warehouse.
Your app can run SQL statements against your Redshift warehouse through the Data API and show the results, with no open database connection to manage. Name either a serverless workgroup or a provisioned cluster, whichever you deploy.
What you need.
Create the keys in your Amazon Redshift account and paste them in. Each one is saved under the name shown, and your app reads it by that name.
- Access key id
AWS_REDSHIFT_ACCESS_KEY_ID- console.aws.amazon.com, IAM, your user, Security credentials, Create access key. A user with redshift-data permissions. Starts with AKIA
- Secret access key
AWS_REDSHIFT_SECRET_ACCESS_KEY- Shown once when the access key is created. Pairs with the access key id
- Region optional
AWS_REDSHIFT_REGION- us-east-1 when empty. Common ones are us-east-1, us-east-2, us-west-2, ca-central-1, eu-west-1, eu-west-2, eu-central-1, ap-south-1, ap-southeast-1, ap-southeast-2, ap-northeast-1, sa-east-1
- Database
AWS_REDSHIFT_DATABASE- The database queries run against by default, like dev
- Workgroup optional
AWS_REDSHIFT_WORKGROUP- console.aws.amazon.com, Redshift Serverless, Workgroups. For a serverless deployment Get it
- Cluster identifier optional
AWS_REDSHIFT_CLUSTER_ID- console.aws.amazon.com, Redshift, Clusters. For a provisioned cluster Get it
How to connect.
-
Open your project, or start a new one from the dashboard.
-
Open the workspace menu and choose Connectors, then pick Amazon Redshift.
-
Paste the keys and save. Your preview restarts, and your app can use the service from then on.
Then ask for the feature
- “Show weekly revenue from the warehouse”
- “Let analysts run read-only queries from the app”
What happens to your keys.
- Each key is saved as a private setting of your project, under the name shown above.
- The AI that builds your app sees only the names. It writes code that reads each key by name, and never the value.
- The values reach your preview and your published app, and never the chat, the code or the logs.
- Open Connectors in your project to replace a key or disconnect the service. Publish again so your live app uses the change.
Service names and logos belong to their owners; Crisp is not affiliated with them. A service changes its keys and pages now and then. Found something out of date? Tell us and we will correct it.
Ask for the feature, and Crisp builds it with Amazon Redshift.
Free plan with $3 of AI usage a month, no credit card. Pro is $20 a month. See pricing.
No credit card. Your code and data stay yours.