Redshift Serverless

1
{
2
  "name": "Redshift Serverless connection",
3
  "type": "redshiftserverless",
4
  "configuration": {
5
    "bulk_sync_staging_schema": "",
6
    "connection_method": "data_api",
7
    "data_api_endpoint": "",
8
    "database": "users",
9
    "endpoint": "acme.12345.us-west-2.redshift-serverless.amazonaws.com:5439",
10
    "iam_role_arn": "arn:aws:iam::012345678910:role/role",
11
    "override_endpoint": false,
12
    "region": "us-west-2",
13
    "s3_bucket_name": "my-bucket",
14
    "s3_bucket_region": "us-west-2",
15
    "use_bulk_sync_staging_schema": false,
16
    "use_unload": false,
17
    "workgroup": "default"
18
  }
19
}

1
{
2
  ...
3
  "configuration": {
4
    "query": "SELECT * FROM sampledata.users",
5
    "schema": "sampledata",
6
    "table": "users",
7
    "view": "active_users"
8
  }
9
}

1
{
2
  ...
3
  "target": {
4
      "configuration": {
5
        "created_column": "",
6
        "preserve_table_on_resync": false,
7
        "updated_column": "",
8
        "write_record_timestamps": false
9
    }
10
  }
11
}

1
{
2
  ...
3
  "destination_configuration": {
4
    "advanced": {
5
        "empty_strings_null": false,
6
        "hard_deletes": false,
7
        "table_prefix": "",
8
        "truncate_existing": false
9
    },
10
    "mirror_schemas": false,
11
    "schema": "schema"
12
  }
13
}