CommerceShip Logo
Log inGet access

Export supply chain data to Google BigQuery

Send orders, shipments, invoices, and carrier costs to Google BigQuery for reporting alongside the rest of the business.

Get startedLearn how it works
Reports
Pending
TypeFormatRowsStatus
Invoice Auditcsv1,284Pending
Finance Invoicescsv312Pending
Invoice Auditcsv5,902Pending

Google BigQuery Integration Capabilities

Serverless, highly scalable data warehouse with built-in machine learning.

Tables on a schedule
Orders, inventory, shipments, invoices, returns, and carrier costs sync into Google BigQuery on your cadence
Cost records
Carrier charges are broken out by base rate, surcharge, and accessorial, with the audit result on each invoice line
Joins to business data
Keys match orders and customers, and freight joins to revenue and margin in Google BigQuery
Incremental updates
Only new and changed records are written. No full reloads.

How the Google BigQuery integration works

  1. Connect Google BigQuery

    Add the credentials for your Google BigQuery destination from your CommerceShip account. Access is scoped to writing where you point it and can be revoked from either side.

  2. Choose fields and cadence

    Pick which order, inventory, shipment, invoice, return, and carrier cost tables go to Google BigQuery, map them to your tables, and set the schedule.

  3. Keep Google BigQuery current

    Exports run on a schedule, new records are added as they are created, and each run is logged.

Google BigQuery Integration FAQs

Still have questions?

Export supply chain data to Google BigQuery

Orders, shipments, invoices, and carrier costs export to Google BigQuery on a schedule, mapped to your tables.

Get started

Other Data Destinations

Warehouses, databases, spreadsheets, and file storage you can send the same shipping data to