Redshift URI Format

The Uniform Resource Identifier (URI) definition for Redshift follows this standard:

Identifier Fragments

Namespace: redshift://{cluster_identifier}.{region_name}:{port}
- Scheme = redshift
- Authority = {cluster_identifier}.{region_name}:{port}
Unique name: {database}.{schema}.{table}

redshift://{cluster_identifier}.{region_name}:{port}/{database}.{schema}.{table}

When creating a Redshift integration in Sifflet, you provide a Host parameter that looks like sifflet-dev-redshift.azert43jaj.eu-west-1.redshift.amazonaws.com. It contains both values:
- sifflet-dev-redshift is the cluster identifier
- eu-west-1 is the region name

cluster_identifier and region_name must start with a lowercase letter and include only lowercase letters, numbers and dash (regex: [a-z][a-z0-9-]*)
port number must include only numbers
database, schema and table can have two formats, following Redshift naming standards: quoted format and unquoted format
- unquoted identifier must include only lowercase letters, numbers, underscore and characters included in the Unicode range U+0080 to U+10FFFF
- quoted identifier must be enclosed in double quotes (") and must include only characters included in the Unicode range U+0001 to U+10FFFF. If a double quote character is present in the name, it needs to be escaped with another double quote character in front of it.

redshift://sifflet-dev-redshift.sa-east-1:5439/dev.schema.table
redshift://sifflet-test-redshift.eu-west-1:5439/dev.schema."таблица table お客様"