Troubleshooting BigQuery

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 as well as information about their status, showing success or an error message. These error messages can help you to understand any issues occurring with your BigQuery exports.

To view logs for an export, start in your hub. Under Exports, select BigQuery.

The BigQuery section of the Power My Analytics hub, under Exports.

Find the row of your export and click View Logs.

A log of exports under a scheduled export in the Exports to BigQuery section of the PMA hub.

Each entry will display a message under Information and a timestamp under Logged At.

Troubleshooting BigQuery Errors

  1. BigQuery Export Limitations
  2. Could Not Handle the Request, Error Code 500 or 502
  3. Code 403; Message: Access Denied

    • Related Articles

    • BigQuery Export Limitations

      Your data exports to BigQuery may encounter errors in certain situations such as large export sizes. This article will help you identify and resolve common BigQuery export issues including timeout errors, "Failed to Fetch" errors, and hung exports. ...

    • Troubleshooting Data Exports

      Power My Analytics allows Custom plan subscribers to export marketing data from Data Builder reports to destinations like BigQuery, MySQL, Azure SQL Database, PostgreSQL, Amazon S3, and FTP. This article is a central index of troubleshooting ...

    • Power My Analytics' Sovereign SQL Warehouse Solution

      Power My Analytics offers a Sovereign SQL Warehouse solution with the Custom plan. This article will help you learn about its uses and how to get started. The Sovereign SQL Warehouse gives you complete ownership of your data by storing it in your own ...

    • Basic Troubleshooting

      Most errors can be solved easily and independently. This article will guide you through some basic troubleshooting steps to get your reports looking great as quickly as possible. Click "See Details" on the Error Description If your report was made ...

    • How to Add a User to BigQuery

      To add a user to Google BigQuery, their account must be granted the appropriate permissions in Google Cloud Platform (GCP). To grant an account access to your BigQuery instance, follow these instructions: 1. Log in to Google Cloud Console at ...