Skip to main content

Required settings

  • Redshift endpoint
  • Schema name
  • Service account
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;
GRANT CREATE, USAGE ON SCHEMA schema_name TO artie_transfer;

Advanced

Artie will create the table with a SUPER data type if the source data is JSON.This is useful:
  • It allows you to use the data as-is without having to parse it into a JSON value.
  • It allows you to store data up to 16MB rather than the VARCHAR(MAX) limit of 65,535 bytes.
I