This is a Jitsu.Classic documentation. For the lastest version, please visit Read about differences here.

πŸ“œ Configuration

Configuration UI

πŸ‘©β€πŸ”¬ Extending Jitsu

Destination Extensions
Source Extensions
API Specs

Jitsu Internals

Jitsu Server


Jitsu supports Redshift as a destination. For more information about Redshift see docs. Redshift destination can work in stream and batch modes. In stream mode Jitsu uses plain insert statements for storing data. In batch mode Jitsu writes incoming events in formatted file on the AWS S3 and uses COPY command to store data from AWS S3 files into Redshift.


Redshift destination config consists of the following schema:

    type: redshift
      db: my-db
      port: 5439
      schema: myschema
      username: user
      password: pass
        connect_timeout: 300
      access_key_id: abc123
      secret_access_key: secretabc123
      bucket: my-bucket
      region: us-west-1
      folder: my_redshift

'datasource' field

Field (*required)TypeDescriptionDefault value
host*stringHost of destination.-
portintPort of destination.5439
db*stringDatabase of destination.-
schemastringSchema of destination.public
username*stringUsername for authorization in a destination.-
passwordstringPassword for authorization in a destination.-
parametersobjectConnection parameters.connect_timeout=600

's3' section


Create AWS S3 bucket and add IAM permissions for using Redshift in batch mode:

  • Create your AWS S3 bucket.
  • Create your AWS IAM User and save its credentials: Access key ID and Secret Access Key.
  • Create IAM Policy with clear name (e.g. jitsu-redshift-policy) and attach it to created user with the following JSON:

Replace YOUR_BUCKET_ARN with your bucket ARN:

  "Version": "2012-10-17",
  "Statement": [
      "Sid": "VisualEditor0",
      "Effect": "Allow",
      "Action": [
      "Resource": [