I receive “access denied, the user does not have permissions to run a query” errors when trying to use the driver.
To be able to query projects in Google BigQuery, the user must have at least Reader status on the project.
To view and update permissions that are members of your project, go to https://console.developers.google.com/, select your project from the drop-down near the top, select “Permissions” in the navigation panel on the left-hand side, and make sure the user you are calling with is at least a “Reader” on the project.
I cannot query the publicdata project, I get the following error: “Access Denied: Job publicdata:<… snip …> The user does not have permission to run a query in project publicdata”
The Billed Project for the DSN must be set to a project in BigQuery that has billing details associated with it. You cannot use the publicdata set as the Billed Project, or you will get the above error.
Can I use BigQuerySQL?
The driver, by default, works in SQL mode and expects SQL-92 queries, not BigQuerySQL. You can change this via the DSN configuration by enabling “Use Native Query” as described in the user guide.
How are arrays handled in the driver
The driver returns arrays as raw JSON chunks
Does the driver support write-back?
No, Google BigQuery itself is append-only so at this time it’s not feasible to add full-writeback.
What are the differences between the Simba and Google version of the BigQuery drivers?
Simba has a relationship with Google that allows them to redistribute the driver to BigQuery users. If you are looking to use the driver internally we recommend acquiring a copy of the driver from them. If you are looking to commercialize or redistribute the driver please contact firstname.lastname@example.org
Do I need a License File?
The Google BigQuery Driver downloaded from the Simba website will include an email providing a .lic file which will need to be installed use the driver. Full instructions on how to do this are provided in the email. If you downloaded the driver from the Simba website and did not receive an email, please check your email spam folder as strict filters can occasionally classify this as junk.
As of current, the version of the driver downloaded from the Google BigQuery website does not require installation of .lic file