Skip to content

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 columnA timestamp column such as updated_at fetches only new or changed rows on later runs.
column descriptionsColumn descriptions in the schema give Si context when proposing a mapping.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
DeveloperDataxLand
Licenseproprietary

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.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
GMV (gross merchandise value)Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds).Currency
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Contribution marginNet 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 costCurrency
Marketing spendTotal cost of marketing campaigns by spend date.Currency

Connect BigQuery in 4 steps

  1. 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. 2

    Add the source

    In the workspace choose Add source → BigQuery, enter project, dataset and the JSON key, click Test connection.

  3. 3

    Pick tables and sync modes

    Pick tables and Full or Incremental (cursor, primary key) for each.

  4. 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

Ask Si about your BigQuery data →BigQuery + Google Ads →All data sources →

Connect BigQuery and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes