Redshift
Setting up the Redshift connector
| No | Item | Required | Example | Notes |
|---|---|---|---|---|
| 1 | Host | Yes | Host Endpoint of the Redshift Cluster (must include the cluster-id, region and end with .redshift.amazonaws.com). | |
| 2 | Port | Yes | 5439 | Port of the database. |
| 3 | Database | Yes | master | Name of the database. |
| 4 | Schemas | No | public | The list of schemas to sync from. Specify one or more explicitly or keep empty to process all schemas. Schema names are case sensitive. |
| 5 | Username | Yes | Username to use to access the database. | |
| 6 | Password | Yes | Password associated with the username. | |
| 7 | JDBC URL Params | No | Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3). |
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.