Redshift Serverless (2022-12-12)

Connection

Configuration

NAME	TYPE	DESCRIPTION	REQUIRED	READONLY
database	string		true	false
workgroup	string		true	false
region	string		false	false
override_endpoint	boolean		false	true
data_api_endpoint	string	Example: https://redshift-data.us-west-2.amazonaws.com (required if “ 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     "region": "us-west-2",
9     "workgroup": "default"
10   }
11 }

Model Sync

Source

Configuration

NAME	TYPE	DESCRIPTION	REQUIRED	READONLY
query	string		false	false
schema	string	Schema	false	false
table	string	Table	false	false
view	string	View	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 }

Type handling

Destination types

POLYTOMIC TYPE	REDSHIFT SERVERLESS TYPE
`array<>`	`SUPER`
`bigint`	`BIGINT`
`boolean`	`BOOL`
`date`	`DATE`
`datetime`	`TIMESTAMP`
`decimal(precision, scale)`	`NUMERIC(precision,scale)`
`double`	`FLOAT8`
`int`	`INTEGER`
`json`	`SUPER`
`jsonarray`	`SUPER`
`number`	`NUMERIC(38,18)`
`object{}`	`SUPER`
`single`	`FLOAT4`
`smallint`	`SMALLINT`
`string`	`VARCHAR(MAX)`
`time`	`VARCHAR(255)`

Source types

REDSHIFT SERVERLESS TYPE	POLYTOMIC TYPE
`4000`	`json`
`BIGINT`	`bigint`
`BOOL`	`boolean`
`BOOLEAN`	`boolean`
`BPCHAR`	`string`
`CHAR`	`string`
`CHARACTER`	`string`
`CHARACTER VARYING`	`string`
`DATE`	`date`
`DECIMAL`	`number`
`DECIMAL(precision, scale)`	`decimal(precision, scale)`
`DOUBLE PRECISION`	`double`
`FLOAT`	`double`
`FLOAT4`	`single`
`FLOAT8`	`double`
`INT`	`int`
`INT2`	`smallint`
`INT4`	`int`
`INT8`	`bigint`
`INTEGER`	`int`
`NCHAR`	`string`
`NUMERIC`	`number`
`NUMERIC(precision, scale)`	`decimal(precision, scale)`
`NVARCHAR`	`string`
`REAL`	`single`
`SMALLINT`	`smallint`
`TEXT`	`string`
`TIME`	`time`
`TIME WITH TIME ZONE`	`time`
`TIME WITHOUT TIME ZONE`	`time`
`TIMESTAMP`	`datetime`
`TIMESTAMP WITH TIME ZONE`	`datetime`
`TIMESTAMP WITHOUT TIME ZONE`	`datetime`
`TIMESTAMPTZ`	`datetime`
`TIMETZ`	`time`
`VARCHAR`	`string`

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	"region": "us-west-2",
9	"workgroup": "default"
10	}
11	}

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