Bigquery Simba ODBC Driver: Error interacting with REST API The user does not have bigquery.datasets.create permission in project
When you configure the Simba ODBC drivers for Google bigquery and execute a SQL Query for the first time, you get the below error message:
Error interacting with REST API The user does not have bigquery.datasets.create permission in project xyz
- Simba driver requires you to configure a default dataset name to store the results of large datasets. Even though your query doesn't return large result sets, it is required that you configure that field
- Open up your ODBC driver settings. You can do that by hitting the windows button and search for "odbc"
- Open the Simba driver and click on Advanced settings, the below window will open up. Type in an EXISTING dataset name in bigquery in the field "Dataset Name for Large Result Sets"
- Click Save
- Disconnect and reconnect from your client tool
The error should now be gone
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds