BigQuery Export Limitations

Your data exports to BigQuery may encounter errors in certain situations such as large export sizes. This article will show you how to identify and correct errors with your BigQuery exports.

Date Field Requirement

Data Builder reports exported to BigQuery must include at least one date field.

Without a date field, the export will fail to complete successfully.

To resolve this issue:

1. Go to Reports > Data Builder and locate your report.
2. Click the three-dots action menu and select Edit.
3. Add the date field Date to your report.
4. Click Save Changes and run your export again.

Export Limitations

If you are using connectors other than Facebook Ads or GA4, make sure the report you are trying to export contains fewer than 40,000 rows of data. If you are backfilling a large amount of your historical data into BigQuery, you may need to take additional steps to make sure your exports are under BigQuery's limits. This limitation does not apply to Facebook Ads or GA4. 

Your export should run in under 10 minutes. If the export runs for 30 minutes or more, it has hung and needs to be cancelled. To stop the hung export, click Edit Export.

Do not make any changes to the export. Click Update.

The hung export is now stopped.

How to accommodate large datasets

If your data has caused the export to hang, try segmenting the overall date range into two smaller date ranges. Edit the report in Data Explorer to use the first date range, then go to BigQuery and run your export.

If your export completes successfully: 

1. Return to Data Explorer.
   
2. Edit your report and set Date Range to the second date range.
   
3. Go to BigQuery and run your export again.

If your export is unsuccessful:

You may need to segment the overall date range into four or more date ranges.

1. Reduce the size of the date range until the export runs successfully, indicating this range is within BigQuery's export limits.
   
2. Run the export for each date range according to the instructions above.
   

• Related Articles

• Troubleshooting BigQuery

  When troubleshooting BigQuery, you may need to view your BigQuery export logs. This article will show you how to check the logs and see details about any errors. Viewing Export Logs Your BigQuery export logs show a timestamped record of your exports ...

• How to Export to BigQuery

  Once you have a report ready in Data Builder, you are able to export it to BigQuery. This export option is included in the Custom plan. Follow the instructions in this article to get started. Grant Required Roles and Permissions A successful ...

• Error: Exporting report '[report name]', the owner of the report has left the organization. Please assign a new owner.

  This article explains what to do when you encounter an error message indicating that a report owner has left your organization when attempting to export to BigQuery. Error Message Error: Exporting report '[report name]', the owner of the report has ...

• YouTube Analytics Data Connector User Guide

  YouTube Analytics provides valuable insights into your channel's performance, audience engagement, and content effectiveness. This guide will walk you through the process of connecting YouTube Analytics to Power My Analytics, creating reports, and ...

• How to Export to PostgreSQL

  Our PostgreSQL export feature enables flexible access to your data in the form of tables in a PostgreSQL database hosted on the server of your choice. Once you've prepared a report in Data Builder, you're ready to export your data to your PostgreSQL ...