Configuring your connectionsConnection configurations

Redshift Serverless

Connection

Description

Configuration

NAMETYPEDESCRIPTIONREQUIREDREADONLY
databasestringtruefalse
workgroupstringtruefalse
override_endpointbooleanfalsetrue
data_api_endpointstringExample: https://redshift-data.us-west-2.amazonaws.com (required if override_endpoint is “true”)falsefalse
iam_role_arnstringtruefalse
external_idstringfalsetrue

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

NAMETYPEDESCRIPTIONREQUIREDREADONLY
querystringfalsefalse
schemastringSchemafalsefalse
tablestringTablefalsefalse
viewstringViewfalsefalse

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