CockroachDB

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

Connect CockroachDB

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

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

Field	Type	Required	Description
Host	string	Yes	Hostname of the database.
Port	integer	Yes	Port of the database. Default `5432`.
DB Name	string	Yes	Name of the database.
User	string	Yes	Username to use to access the database.
Password	string, secret	No	Password associated with the username.
JDBC URL Parameters (Advanced)	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 '&'. (Eg. key1=value1&key2=value2&key3=value3).
Connect using SSL	boolean	No	Encrypt client/server communications for increased security. Default `false`.

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