Connection

Description

Configuration

NAME	TYPE	DESCRIPTION	REQUIRED	READONLY
database	string		true	false
workgroup	string		true	false
override_endpoint	boolean		false	true
data_api_endpoint	string	Example: https://redshift-data.us-west-2.amazonaws.com (required if `override_endpoint` is “true”)	false	false
iam_role_arn	string		true	false
external_id	string		false	true

Example

1 {
2   "name": "redshiftserverless connection",
3   "type": "redshiftserverless",
4   "configuration": {
5     "data_api_endpoint": "",
6     "database": "users",
7     "iam_role_arn": "arn:aws:iam::012345678910:role/role",
8     "workgroup": "default"
9   }
10 }

Model Sync

Source

Configuration

NAME	TYPE	REQUIRED	READONLY
query	string	false	false
schema	string	false	false
table	string	false	false
view	string	false	false

Example

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

Target

N/A

Bulk Sync

Source

N/A

Destination

N/A

Getting started

Configuring your connections

Code examples

Redshift Serverless

Connection

Description

Configuration

Example

Model Sync

Source

Configuration

Example

Target

Bulk Sync

Source

Destination

1	{
2	"name": "redshiftserverless connection",
3	"type": "redshiftserverless",
4	"configuration": {
5	"data_api_endpoint": "",
6	"database": "users",
7	"iam_role_arn": "arn:aws:iam::012345678910:role/role",
8	"workgroup": "default"
9	}
10	}

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