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.
What SQL does the driver support?
By default, the driver will use BigQuery Standards SQL. You can also configure the driver to use Legacy SQL.
How are arrays handled in the driver
The driver returns arrays as raw JSON chunks
Does the driver support write-back?
Yes, INSERT, UPDATE, and DELETE are supported.
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 solutions@simba.com
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.
Currently, the version of the driver downloaded from the Google BigQuery website does not require installation of .lic file