Pricing

The BigQuery Data Transfer Service charges monthly on a prorated basis. You are charged as follows:

Data source Monthly charge (prorated) Notes
Campaign Manager

$2.50 per unique Advertiser ID. Advertiser IDs in the impression table.

1
Cloud Storage

No charge. BigQuery Quotas and limits apply.

1
Amazon S3

No charge. BigQuery Quotas and limits apply.

1,2,3
Google Ads

$2.50 per unique Customer ID. ExternalCustomerIDs in the Customer table, including zero impression Customer IDs.

1
Google Ad Manager

$100 per Network ID

1
Google Play

No charge through August 31, 2018. Effective September 1, 2018:

$25 per unique Package Name in the Installs_country table.

1
Search Ads 360

No charge. BigQuery Quotas and limits apply.

1
YouTube Channel

$5 per Channel

1
YouTube Content Owner

$5 per 1,000 unique Channels ($0.005 per unique Channel). Channel IDs are in the content_owner_basic_a3 table.

1
Data warehouse Monthly charge (prorated) Notes
Teradata

No charge. BigQuery Quotas and limits apply.

1, 2, 3, 4
Amazon Redshift

No charge. BigQuery Quotas and limits apply.

1, 2, 3

Notes on transfer pricing

All transfers

1. After data is transferred to BigQuery, standard BigQuery storage and query pricing applies. For additional pricing details, contact Sales.

Migrations from other platforms

2. Extraction, uploading to a Cloud Storage bucket, and loading data into BigQuery is free.

3. Costs can be incurred outside of Google by using the BigQuery Data Transfer Service, such as platform egress charges.

Teradata migrations

4. Data is not automatically deleted from your Cloud Storage bucket after it is uploaded to BigQuery. Consider deleting the data from your Cloud Storage bucket to avoid additional storage costs. See Cloud Storage pricing.

Calculating unique IDs

Each transfer you create generates 1 or more runs per day. Each run maintains a record of each unique ID encountered and the date the transfer run completes. IDs are only counted on the day the transfer completes. For example, if a transfer run begins on July 14th but completes on July 15th, the unique IDs are counted on July 15th.

If a unique ID is encountered in more than one transfer run on a particular day, it is counted only once. Unique IDs are counted separately for different transfers. If a unique ID is encountered in runs for two separate transfers, the ID is counted twice.

Calculating backfill charges

If you schedule a backfill, a transfer run is scheduled for each day. You are then charged based on the method described in Calculating unique IDs.

Stopping BigQuery Data Transfer Service charges

To stop incurring charges, disable or delete your transfer.

BigQuery Data Transfer Service pricing examples

Example 1: You have 1 transfer with 3 runs that complete on the same day.

  • The first run records the following unique IDs: A, B, and C
  • The second run records: A
  • The third run records: C and D

Because all runs finish on the same day, you are charged based on 4 unique IDs: A, B, C, D. Because ID A and ID C were recorded in two different runs that completed on the same day, IDs A and C are counted only once. If the 3 transfer runs complete every day for a month, your monthly charge is based on 4 unique IDs. If the transfer runs complete fewer times than the number of days in the month in which they run, the charges are prorated.

Example 2: You have multiple transfers with runs that complete on the same day.

  • Transfer 1 runs and records the following unique IDs: A, B, and C
  • Transfer 2 runs and records: A
  • Transfer 3 runs and records: C and D

Because the unique IDs are counted in runs for different transfers, you are charged based on 6 unique IDs: A, B, and C from transfer 1's run; A from transfer 2's run; and C and D from transfer 3's run. If the transfer runs complete fewer times than the number of days in the month in which they run, the charges are prorated.

Segítségére volt ez az oldal? Tudassa velünk a véleményét:

Visszajelzés küldése a következővel kapcsolatban:

BigQuery Data Transfer Service