Redshift URI format
URI definition for Redshift follows this standard:
Identifier fragments:
- Namespace:
redshift://{cluster_identifier}.{region_name}:{port}
- Scheme =
redshift
- Authority =
{cluster_identifier}.{region_name}:{port}
- Scheme =
- Unique name:
{database}.{schema}.{table}
URI format:
redshift://{cluster_identifier}.{region_name}:{port}/{database}.{schema}.{table}
How to find my cluster identifier and region name:
- When creating a redshift integration in Sifflet you have to provide an Host parameter that looks like that
sifflet-dev-redshift.azert43jaj.eu-west-1.redshift.amazonaws.com
. Both the parameters we are looking for are heresifflet-dev-redshift
is the cluster identifiereu-west-1
is the region name
Parameters limitations:
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 numbersdatabase
,schema
andtable
can have two format, following Redshift naming standards: quoted format and unquoted format- unquoted identifier must include only lowercases letters, numbers, underscore and characters included in the unicode range U+0080 to U+10FFFF
- quoted identifier needs to be quoted using 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.
Examples:
redshift://sifflet-dev-redshift.na-south-12:5439/dev.schema.table
redshift://sifflet-test-redshift.eu-west-1:5439/dev.schema."таблица table お客様"
Updated 5 months ago