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
The assistant can read the schema and run queries against:
- BigQuery — upload a service-account JSON key.
- Snowflake — account, user, password.
- Databricks — server hostname, HTTP path, access token.
- PostgreSQL / Redshift — host, database, user, password.
Other connection types exist on the platform, but the guided flow and queries only work with the ones above.
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. Neither the assistant nor the queries ever write to
your Data Platform, so you can hand it a read-only role and still use the whole
product.
How many tables the assistant looks at
One assistant session inspects up to 40 tables and samples a few rows from each to understand what is in them. That is why narrowing to a schema helps: the proposals are far better than pointing at a whole database.