Redshift

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;

Advanced

JSON data as SUPER

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.

S3How to configure S3 as a destination in Artie. With S3, Artie will write incoming delta files in Parquet format to the specified bucket and folder.

⌘I

Getting Started

Pipelines

Connectors

Monitoring

Artie Dashboard

Required settings

Creating a service account

Advanced

​Required settings

​Creating a service account

​Advanced

Required settings

Creating a service account

Advanced