Before connecting, ensure that you whitelist Fabi.ai’s IP addresses in your firewall or security group settings:

Creating a service account user

1. Log in to the AWS Management Console

Open the AWS Management Console and navigate to your Redshift cluster.

Use a SQL client or AWS Query Editor v2 to connect to your Redshift cluster. Documentation: Connecting to an Amazon Redshift cluster

Run the following SQL command to create a new user. Replace service_account_user with your desired username and password with a secure password.

CREATE USER service_account_user PASSWORD 'secure_password';

Fabi.ai needs read access to the schemas you wish to query.

GRANT USAGE ON SCHEMA schema_name TO service_account_user;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO service_account_user;

Once you’ve generated your service user credentials, follow the steps in Connecting to Your Data

For information about our industry-leading security practices, check out our Security hub.