Your own dataset
twelfth queries tables in your Google Cloud project. Access is a grant you control, and removing it ends twelfth's access.
Google BigQuery integration
Early accessReads in · write-back available as an option
Put the warehouse you already model to work on commercial decisions.
Yes, twelfth connects to Google BigQuery. It reads the tables your team keeps in your own dataset, and can write back to your warehouse as an option. BigQuery is in early access.
DATA IN / 01
What twelfth reads from Google BigQuery.
Transaction and customer data
If your warehouse does not already hold the tables twelfth serves from, raw transaction and customer data can be landed in a dataset for twelfth to read in.
A connection run for you
Some teams have twelfth operate the warehouse connection and import, with its health and freshness shown to the workspace.
FOR YOUR TEAM / 02
What it helps your team do.
Start from numbers the business already trusts
The warehouse your analysts maintain becomes the evidence behind pricing, inventory, range, promotion and supplier recommendations.
Keep decisions next to your reporting
With write-back, what the team decided in twelfth can sit alongside your own data, so dashboards show the recommendation and the call that was made.
Stay in control of access
The connection holds no key or password. Access is an IAM grant in your own project, which you can revoke at any time.
FAQ / 03
Google BigQuery integration FAQ.
- Q01Does twelfth write to my BigQuery warehouse?
- It can, as an option. twelfth reads the dataset you grant, and can write back to your warehouse if your team wants it to.
- Q02Does twelfth store a BigQuery key or password?
- No. The connection stores your project, dataset and location, which are not secrets. Access is governed by an IAM grant in your own Google Cloud project, and removing it ends twelfth's access immediately.
- Q03Is the BigQuery integration available to every workspace?
- It is in early access and being rolled out gradually. If your team wants it, ask your twelfth contact to turn it on for your workspace.
- Q04Can twelfth run the warehouse connection for us?
- Yes. In the twelfth-managed model twelfth operates the connection and import, and the workspace sees its health and freshness without credentials to manage.
- Q05What if our data is not modelled for twelfth yet?
- Raw transaction and customer data can be landed in a BigQuery dataset for twelfth to read in, for teams that do not already produce the tables twelfth serves from.
RELATED / 04
Terms and connectors to know.
- Snowflake integration
Planned · available on request. twelfth's Snowflake connector is planned: queries against your own Snowflake database, scoped to the data you grant. See what it will read and how to ask.
- Databricks integration
Planned · available on request. twelfth's Databricks connector is planned: lakehouse queries against your own Unity Catalog, scoped to the data you grant. See what it will read.
- Retail Express integration
Live · managed by twelfth. twelfth works with Retail Express as a managed integration: products, stock, sales, supplier history and price history behind ranked retail decisions.
- All integrations
Every system twelfth connects to, live and planned.
NEXT MOVE
See Google BigQuery and twelfth in action.
See how Google BigQuery data becomes a clear commercial recommendation your team can act on.