Square to BigQuery integration for analytics-ready sales data

The Square to BigQuery integration from Adapters loads payments, orders, line items, refunds, and processing fees from the Square API into partitioned BigQuery tables on an incremental schedule, so cohort, margin, and reconciliation models run on a full multi-location history instead of a manual export. Field mapping takes about a minute and no code is required.

Try it in the live demo

Input

Output

Field mapping auto-plugged · tap a port to rewire

5 sample records ready

Last updated July 2026

What running Square to BigQuery by hand costs you

The Square API scopes data per location and paginates by cursor with rate limits, so backfilling every location into BigQuery by hand is slow to script and brittle.
Order edits, refunds, and voided payments change records after the sale, and a naive nightly dump into BigQuery misses those updates.
True margin blends Square sales with cost of goods, fees, and ad spend, which needs a partitioned warehouse table, not a folder of exported reports.

The field mapping, out of the box

These cables are pre-wired when you pick the pair. Rewire any of them, or add your own, in the same visual data mapping tool you use for every adapter.

Input / SQUARE

Output / BIGQUERY

payment.id

fct_payment.payment_id

payment.amount_money.amount

fct_payment.amount

payment.created_at

fct_payment.created_at

order.line_item.uid

fct_order_line.line_id

payment.location_id

dim_location.location_id

payment.updated_at

fct_payment.loaded_at

Transforms included

Incremental loads use the Square updated_at watermark so edits, refunds, and voids flow through on the next run; minor-unit amounts (cents) cast to BigQuery NUMERIC dollars, ISO 8601 timestamps land as TIMESTAMP in UTC, tables partition by payment date, and line items land in their own table so margin and cohort models read one clean, deduplicated sales history.

How it goes live

Three steps, minutes end to end, covered by flat data integration pricing from $49 a month.

STEP 01

Pick the pair

Connect Square and BigQuery with scoped credentials. About a minute each.

STEP 02

Confirm the mapping

The cables above are pre-wired. Adjust any field, preview the transform on sample records, done.

STEP 03

Schedule the sync

Hourly down to every minute, with retries, alerting, and a full log on every run.

Try it in the live demo Preloads SQUARE → BIGQUERY with sample records

Square to BigQuery sync: common questions

How does the Square to BigQuery sync work?

How much does the Square BigQuery integration cost?

Pricing is flat and monthly: Starter at $49, Growth at $149, Scale at $399. Every plan includes this pair, visual field mapping, and per-record logs. There are no per-task or per-row fees, so the bill stays the same as volume grows.

How often can Adapters sync Square to BigQuery?

Hourly on Starter, every 5 minutes on Growth, and down to every minute on Scale. Failed records retry automatically with backoff, and alerting plus a full per-record log come standard on every run.

Do I need to write code to connect Square and BigQuery?

No. Fields are auto-mapped the moment you pick the pair, and you can rewire any mapping visually before the first sync. Incremental loads use the Square updated_at watermark so edits, refunds, and voids flow through on the next run; minor-unit amounts (cents) cast to BigQuery NUMERIC dollars, ISO 8601 timestamps land as TIMESTAMP in UTC, tables partition by payment date, and line items land in their own table so margin and cohort models read one clean, deduplicated sales history.

More pairs from the API connector library

Browse the full api connector library, or request a pair you do not see.

Square and BigQuery, finally in agreement

Map the pair once and let it sync on schedule. Flat price from $49 a month, no per-task fees.

Try the live demo

No credit card required.