Skip to content
sandadocs
Console Start free trial

Redshift

Connect Redshift to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.

View as Markdown

Connect Redshift

  1. Open the catalogue. In the console, go to Data · Connections and press New connection.
  2. Choose Redshift. It is listed under databases; you can also search for it by name.
  3. Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
  4. Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
  5. Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.

Configuration fields

What the connection form asks for. Required fields are marked; the rest are optional.

Field Type Required Description
Host string Yes Host Endpoint of the Redshift Cluster (must include the cluster-id, region and end with .redshift.amazonaws.com).
Port integer Yes Port of the database. Default 5439.
Database string Yes Name of the database.
Schemas array No The list of schemas to sync from. Specify one or more explicitly or keep empty to process all schemas. Schema names are case sensitive.
Username string Yes Username to use to access the database.
Password string, secret Yes Password associated with the username.
JDBC URL Params string 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).

Something unclear or out of date? Tell us, and we will fix the page.