Skip to main content

Connecting to Redshift

Amazon Redshift is PostgreSQL-compatible, so configuring Veezoo closely mirrors other SQL databases, but the SQL below is tailored for Redshift.

Prerequisites​

Gather the following information before creating the connection:

  • Redshift endpoint hostname
  • Port number (default: 5439)
  • Database name you want to expose to Veezoo
  • Credentials for the read-only database user you created

Using the Read-Only User​

Create a read-only user and grant access to the schemas you plan to use with the following commands (replace your_schema with your schema name, choose a strong password for the user):

CREATE USER veezoo_readonly WITH PASSWORD 'choose_a_strong_password';

GRANT USAGE ON SCHEMA your_schema TO veezoo_readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA your_schema TO veezoo_readonly;

ALTER DEFAULT PRIVILEGES IN SCHEMA your_schema
    GRANT SELECT ON TABLES TO veezoo_readonly;

Save the credentials for the user in a password manager so it's stored securely. Repeat the GRANT and ALTER DEFAULT PRIVILEGES statements for any additional schemas you want Veezoo to access.

Configure the Connection in Veezoo​

When setting up the database connection in Veezoo Studio, choose Amazon Redshift. Follow the UI steps described in Connect to a SQL database. Use the host, port, database name, and the read-only credentials created above when filling out the form.