Databases
Connect BigQuery to DataxLand
The BigQuery connector is a native DataxLand source for businesses that already gather data in Google BigQuery, such as the GA4 export, ad tables or app data. DataxLand loads the tables you pick into the workspace's own warehouse, fully or incrementally by a timestamp column, and Si proposes how to read them in your industry's standard model. You get dashboards, defined metrics and Q&A without building a reporting layer on BigQuery yourself.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with BigQuery
- Bring order and ad cost tables already in BigQuery into a profit-by-channel dashboard.
- Compute true ROAS from net revenue in your warehouse instead of ad-platform revenue.
- Let the sales team ask Si about numbers without writing SQL or opening the console.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| <dataset>.<table> | Each table you pick becomes its own warehouse table, original column names kept. |
| cursor column | A timestamp column such as updated_at fetches only new or changed rows on later runs. |
| column descriptions | Column descriptions in the schema give Si context when proposing a mapping. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Developer | DataxLand |
| License | proprietary |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Valid orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| Average order value | Line revenue after discounts divided by valid orders.= line_net_total / Valid orders | Currency |
| GMV (gross merchandise value) | Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds). | Currency |
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Blended ROAS | Actual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spend | Number |
| Contribution margin | Net revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return cost | Currency |
| Marketing spend | Total cost of marketing campaigns by spend date. | Currency |
Connect BigQuery in 4 steps
- 1
Create a service account
In Google Cloud, create a service account that can read the needed datasets and run queries, and download its JSON key.
- 2
Add the source
In the workspace choose Add source → BigQuery, enter project, dataset and the JSON key, click Test connection.
- 3
Pick tables and sync modes
Pick tables and Full or Incremental (cursor, primary key) for each.
- 4
Review Si's proposal
Si proposes what each table is and how they join; you approve and build.
Limits and caveats
- Each load runs queries on BigQuery billed to your Google Cloud project; incremental loads scan less data.
- Incremental mode cannot see deleted rows; CDC is only available for PostgreSQL.
- Si runs read-only SQL within query and cost limits while investigating; queries over the limit wait for a technical user's approval.
Frequently asked questions
Does data leave BigQuery?
Yes, the tables you pick are copied to the workspace warehouse so dashboards and Si read fast, without querying BigQuery on every view.
How is the JSON key stored?
Encrypted at rest and never shown again; grant the service account the least privilege it needs.
Does it work with the GA4 export to BigQuery?
Yes, pick the event tables you need; large event tables should load incrementally.
Dashboard templates that use this source
Connect BigQuery and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes