BigQuery Error: Code 403; Message: Access Denied

This article will assist you with the following errors:

Code: 403; Message: Access Denied: BigQuery BigQuery: Streaming insert is not allowed in the free tier (accessDenied)

The error log for BigQuery in your PMA hub.

Code: 403; Message: Access Denied: Dataset: Permission denied on dataset (or it may not exist).(accessDenied)

Cause

Streaming insert is not allowed in the free tier

You are currently using BigQuery's free tier. The free tier does not allow PMA exports to BigQuery.

Permission denied on dataset (or it may not exist)

The Google account you are using does not have write access to BigQuery.

Solution

Upgrade your BigQuery plan

If the error was due to using BigQuery's free tier, you'll need to upgrade your plan in order to enable exports from PMA. We use streaming inserts to export data to BigQuery, and Google currently prices streaming inserts to BigQuery at $0.01 USD per 200MB. For more details, please see Google's BigQuery data ingestion pricing.

Enable write access to BigQuery

If the error is due to permission being denied for the dataset, make sure to enable write access to BigQuery on the Google account you're using when selecting a BigQuery destination. Your BigQuery admin can check your Google account and grant write permissions to BigQuery.