Required settings

To integrate Redshift with Artie, we will need the following settings.

  1. Redshift endpoint
  2. Service account
  3. Schema name

Redshift endpoint

Creating a service account

CREATE USER artie_transfer WITH PASSWORD 'password';
GRANT SELECT, INSERT, UPDATE, DELETE, DROP, ALTER ON ALL TABLES
    IN SCHEMA schema_name TO artie_transfer;