Warehouse Sync

Create warehouse connection

Changed on

Connects Snowflake, BigQuery, Redshift or Postgres. Sequenzy runs a test query before saving; nothing is saved when it fails. Redshift and Postgres hosts must resolve to public addresses. Requires warehouse:write.

post/warehouse-connections

Request

  • Base URL
    https://api.sequenzy.com/api/v1
  • URL
    https://api.sequenzy.com/api/v1/warehouse-connections
  • Auth
    HTTP bearer

Request body

namestring required
provider'snowflake' | 'bigquery' | 'redshift' | 'postgres' required
configobject required

Non-secret settings. snowflake: account, username, warehouse, database, schema, role. bigquery: projectId, location. redshift and postgres: host, port (default 5439 or 5432), database, username, sslMode (require or verify-full, default require).

credentialsobject required

Secrets, stored encrypted and never returned. snowflake: privateKey (PKCS#8 PEM) and optional privateKeyPassphrase. bigquery: serviceAccountJson (the key file contents). redshift and postgres: password.

Response

Connection created

successboolean

Example response

{
  "success": true
}

Changes