Skip to main content
POST
Create Warehouse Connection
Connects a data warehouse. Sequenzy runs SELECT 1 with the credentials before saving; if it fails, nothing is saved and the response contains the warehouse’s reason. Requires warehouse:write. Use a user that can only read the tables you want to sync. See Warehouse Sync for setup steps per warehouse.

Request

string
required
Display name, up to 255 characters.
string
required
snowflake, bigquery, redshift or postgres.
object
required
Non-secret settings. snowflake: account (for example myorg-myaccount or xy12345.us-east-1), username, warehouse, database, optional schema and role. bigquery: projectId, optional location (for example US). redshift and postgres: host, database, username, optional port (default 5439 or 5432) and sslMode (require, the default, or verify-full). The host must resolve to a public address.
object
required
Secrets, stored encrypted and never returned. snowflake: privateKey (PKCS#8 PEM for key-pair authentication) and optional privateKeyPassphrase. bigquery: serviceAccountJson, the contents of the service account key file. redshift and postgres: password.