What is the Data Warehouse
The Data Warehouse gives your tenant a dedicated Google BigQuery dataset of pre-built SQL views over your support data — conversations, contacts, agents, teams, messages, and more. Once provisioned, you can connect any BI tool that speaks BigQuery, or run SQL directly with a service account key.
This is the answer for teams who’ve outgrown the built-in Analytics dashboards and need to join Atender data with everything else they have in a warehouse.
How it differs from Analytics
Built-in Analytics is for the in-app view: KPIs, dashboards, the 17 standard analytics views. Fast to load, but the dimensions are fixed.
The Data Warehouse is for everything beyond that:
- Custom SQL joins between Atender data and your CRM, billing, or product analytics
- Long-running queries that would time out in the app
- Feeding a BI tool of your choice (Looker Studio, Tableau, Metabase, Sigma, anything that connects to BigQuery)
- Cohort analysis, retention curves, custom funnels — anything that needs SQL flexibility
Both surfaces read from the same underlying data, so numbers should reconcile.
What you get when you provision
When you click Provision Data Warehouse, Atender:
- Creates a dedicated BigQuery dataset for your tenant
- Generates a set of SQL views — conversations, contacts, agents, teams, messages, and others — pre-shaped for analytics use
- Creates a service account scoped to that dataset only
You then download a service account JSON key from Atender’s UI, point your BI tool at the project and dataset, and authenticate with the key.
The data refreshes continuously — there’s no manual sync to schedule. As things happen in Atender, the views see them.
Credentials
Service account keys are stored on Google’s side; Atender hands you the JSON file once at download time. If you lose it, you can’t re-download — you generate a new one. You can revoke all keys at once if a key leaks; existing BI connections will fail until you replace them.
The credentials panel always shows the active key count so you know how many are out there.
Re-provisioning
If Atender ships new views or columns, you may want to re-provision to pick them up. Click Re-provision Views in the Connection Details card. It doesn’t delete your existing credentials or break running queries — it adds and updates view definitions in place.
Limits to know
- One dataset per tenant
- Service account keys: generate as many as you want, but each one is a credential to track
- BI tool support: anything that speaks Google BigQuery works; if your tool doesn’t, this isn’t the right surface