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.

Timeout Errors and "Failed to Fetch" Errors

When exporting large or complex datasets, you may encounter timeout errors or "Failed to Fetch" errors. These errors typically occur when requesting too much data at once, such as a report with many fields covering a long date range.

Common causes of timeout errors:

• Long date ranges (e.g., a full year of data)
• Large number of fields in one report
• Excessive use of live fields (indicated by the lightning bolt ⚡ icon in Schema Explorer)

Understanding Live Fields

Live fields trigger real-time API calls to the source platform each time data is requested. While they provide the most current data, excessive use of live fields can cause timeouts, especially with long date ranges. You can identify live fields in the Schema Explorer by looking for the yellow lightning bolt icon (⚡) next to the field label.

How to Resolve Timeout Errors

To resolve timeout or "Failed to Fetch" errors, try the following approaches:

1. Split by time period: Instead of exporting a full year at once, run separate exports for quarterly segments (Q1, Q2, Q3, Q4).
2. Reduce live fields: Remove fields marked with the ⚡ icon to eliminate real-time API calls. Use Schema Explorer to identify these fields.
3. Limit fields per report: Group related fields into separate reports (e.g., one report for order metrics, another for product metrics, another for customer data).