Required settings

  • Redshift endpoint
  • Schema name
  • Service account

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;
GRANT CREATE, USAGE ON SCHEMA schema_name TO artie_transfer;