BigQuery pricing worked for a Shopify store, from storage to the query that costs $12
7 min read Cost The Adapters team
Field mapping auto-plugged · tap a port to rewire
Plug a source port into
Transform on this cable
JSON in
JSON out
5 sample records ready
BigQuery on-demand pricing is $6.25 per TiB scanned, with the first TiB free each month, plus about $0.023 per GiB a month for storage after the first 10 GiB. For a Shopify store with a few GiB of orders, that is usually a bill under $15, and it is moved by how you query the tables, not by how many orders you take. Loading is free on the shared pool.
Key takeaways
- Queries are billed by bytes scanned. $6.25 per TiB after the first free TiB.
- Storage is cheap and tiered. About $0.023 per GiB a month, less after 90 idle days.
- Partitioning is the lever. One month of orders scans a fraction of the table.
How much does BigQuery cost per month?
It depends on three things you control: how many gibibytes you store, how many bytes your queries scan and how the data gets in. The BigQuery pricing page lists storage by the gibibyte hour, queries by the tebibyte scanned and batch loading at no charge on the shared slot pool. We read the US list on 21 November 2026. Regions differ, and capacity pricing by the slot hour exists for steady heavy workloads, but a store-sized warehouse is almost always on-demand. The sums below use an assumed merchant, because no honest average store exists.
What storage costs for a Shopify dataset
Active logical storage is $0.000031507 per GiB hour, which is about $0.023 a month for each GiB past the free 10. A table or partition nobody modifies for 90 days drops to the long-term rate of $0.000021918 per GiB hour, about $0.016 a month. Shopify orders are mostly append and edit for a few weeks, so older months go long-term on their own.
| Stored data | Monthly storage cost | How we got it |
|---|---|---|
| 10 GiB (a store with two years of orders and refunds) | $0.00 | Inside the first 10 GiB free |
| 50 GiB (many objects, metafields, inventory history) | $0.92 | (50 - 10) x $0.023 |
| 500 GiB (a multi-store group) | $11.27 | (500 - 10) x $0.023 |
| 500 GiB untouched for 90 days | $7.84 | (500 - 10) x $0.016 long-term rate |
The sizes are assumptions to show the shape. Your own figure is in the dataset details in the
console, or in the INFORMATION_SCHEMA.TABLE_STORAGE view. The takeaway is that a
merchant is nowhere near paying real money for storage until the history spans several stores.
What is the BigQuery cost per TB?
On-demand queries cost $6.25 per TiB, and the unit is bytes read from the columns you select, not
rows returned. A LIMIT 10 does not shrink the scan. That is why the same dashboard can
be free or cost a few dollars, as this assumed example shows: a 2 GiB orders table read fifty
times a day.
| Scenario | Scanned a month | Query bill | How we got it |
|---|---|---|---|
| Dashboard reads the whole 2 GiB orders table 50 times a day | 2.93 TiB | $12.06 | 2 GiB x 50 x 30 = 3,000 GiB, minus 1 TiB free, x $6.25 |
| Same dashboard, table partitioned by month, one month read | 0.12 TiB | $0.00 | 3,000 GiB / 24 months = 125 GiB, inside the free TiB |
| Same dashboard selecting 6 of 40 columns on the partitioned table | 0.02 TiB | $0.00 | Columns not selected are not scanned |
Same data, same dashboard, $12.06 against nothing. Partition the orders table by created date, cluster it by the columns you filter on and select only what the chart needs. None of that is a pricing tier. It is table design, and it is set when the table is created, which is the moment a connector decides your schema.
Does loading data into BigQuery cost money?
Batch loading files is free on the shared pool, so a nightly load costs only the storage of the rows. Streaming through the Storage Write API is $0.025 per GiB after the first 2 TiB each month, which a store will not reach. What matters more is a pipeline that reloads the whole store each run. Google's own Shopify transfer is a Preview feature with no charge listed, and its page says every run transfers all available data. A full reload does not add a load fee, but it rewrites tables you then scan, and time travel keeps the replaced bytes for a while. The route is compared line by line on Shopify to BigQuery integration tools.
Is BigQuery free for a small store?
Often close to it. The first 10 GiB of storage and the first 1 TiB of query processing are free every month, and batch loading costs nothing on the shared pool. A merchant with a few GiB of orders and partitioned tables can stay inside both allowances. A tool that reloads everything on a tight schedule can still push scans past them.
The bill that surprises merchants is rarely BigQuery. It is the tool that moves the data, priced per row or per event, which grows in a holiday month. If you want a number you can forecast, compare that unit first. The same exercise for CRM data is on HubSpot to BigQuery connector pricing and Salesforce to BigQuery connector pricing. When the sums come out, a short written note on what was checked helps the next person, and some teams speak it rather than type it, for example by dictating their reconciliation notes aloud.
How is BigQuery storage priced?
By the gibibyte hour, billed monthly. Active logical storage is $0.000031507 per GiB hour. Tables or partitions not modified for 90 days move to the long-term rate of $0.000021918 per GiB hour automatically. The first 10 GiB is free each month. A physical storage option is billed at a different rate, so compare before you switch.
Where Adapters fits
Adapters maps Shopify objects onto typed BigQuery tables, so money lands as NUMERIC beside its currency and created keeps its zone, and it merges changes on the Shopify id instead of reloading the store. Plans are flat from $49 a month with no per-row fee, which leaves BigQuery as the only usage-based line on your invoice. See the BigQuery ETL tools comparison, the Shopify to BigQuery connector, Shopify integration tools and pricing.
Load BigQuery from your apps on a price you can forecast
Map the objects once, land exact types, then sync only what changed. Plans from $49 a month, with no per-row fee to forecast.
The live demo needs no card, and Starter is $49 a month.