Skip to content
Connect a warehouse

Connect a warehouse

Add a connection

In the app, go to Connections → New connection, pick your provider and fill in the credentials. qontexta tests the connection right away and tells you if anything is wrong.

Supported providers

  • BigQuery — upload a service-account JSON key.
  • Snowflake — account, user, password.
  • Databricks — server hostname, HTTP path, access token.
  • PostgreSQL / Redshift — host, database, user, password.
  • Oracle — host, port, service name, user, password.
  • SAP HANA — host, port, user, password.

BigQuery permissions

The service account needs two roles on the project:

  • BigQuery Job User (roles/bigquery.jobUser) — to run queries.
  • BigQuery Data Viewer (roles/bigquery.dataViewer) — to read table schemas.

If a role is missing, the connection test will tell you exactly which one to grant.

Connections are read-only. qontexta never writes to your warehouse.