Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

bigquery storage api pricing

 I need to use the bigquery storage api for what I want. The cost per network capacity is listed on the site, but I want to estimate what the network usage will be specifically.

  How much can you predict if I use the API to extract a table with 10 million rows and 500 columns? It's around 2GB with a big query table, and I'd estimate around 20GB with Python. At this point, is the cost closer to 2 GB or closer to 20 GB?

1 1 4,445
1 REPLY 1

Good day @heedong,

Welcome to Google Cloud Community!

For Storage read API, it has on demand pricing model, you are charged by the number of bytes processed also known as bytes read, this means you will be charged by total amount of the data that you read and the on demand charging will only be based on its usage. Data read within the same locations or from temporary tables results or from Bigquery multi-region (us or eu) to a different Bigquery location (same continent) are free but the pricing for data read or data move from different continents will range from $0.01/GB to $ 0.15/GB. Please also note Egress to a different location has pricing but the ingress is free. 
You can check this documentation about the data extraction pricing including the General Network Usage of BigQuery Storage Read API: https://cloud.google.com/bigquery/pricing#data_extraction_pricing
I also recommend that you use the Pricing Calculator if you want to estimate your costs in Bigquery: https://cloud.google.com/products/calculator

Hope this is helpful!

Top Labels in this Space