Does it cost copying data from one project to another project in BQ via Transfer feature?

Question

Good day,

it is unclear for me if it costs copying data from one project to another project in BQ via the Transfer feature?

Right now we have Scheduled Queries in place for this, but they exponentially increased our billing since we are querying large amounts of data every day while copying everything from Firebase BQ projects to our internal project. I am wondering if Transfer feature in BQ would decrease our billing?

Thanks.

Answer 1

BigQuery Data Transfer Service integrates more and more services.

When we talk about BQ to BQ transfer service it worths knowing the following:

• it works across regions
• it uses the free COPY operation
• it has the same limitations as BQ Copy jobs.

So it doesn't charge you anything because it doesn't run a query, it doesn't export a table to cloud storage (so no files incur costs), instead it uses the COPY operation, which is free.