04 Feb 20 · npack · #Bigquery ·   Bookmark   ×

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

Solution:

  • 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

npack

posted on 04 Feb 20

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