I am trying to load a Big Query table that is based on a Google Spreadsheet into Stata. I am using the Simba ODBC driver for Mac (version 2.1.6), but I get the following error from a simple "select * from table" query:
The ODBC driver reported the following diagnostics [Simba][BigQuery] (20) Query execution failed: Access Denied: BigQuery BigQuery: No OAuth token with Google Drive scope was found. SQLSTATE=HY000
In my odbc.ini file, I have set RequestGoogleDriveScope=1, and am using user authentication for OAuth Mechanism.
I can query this table in Big Query web user interface and in R, and I can load other non-GS tables via ODBC in Stata. I think I need to give Stata/Simba/iodbc permission in https://myaccount.google.com/permissions (like BQ Client Tools and bigquery R has), but I am not sure how to do that or even that it necessary.
I would love to know what I am missing here.
Cross-posted here.
The ODBC driver reported the following diagnostics [Simba][BigQuery] (20) Query execution failed: Access Denied: BigQuery BigQuery: No OAuth token with Google Drive scope was found. SQLSTATE=HY000
In my odbc.ini file, I have set RequestGoogleDriveScope=1, and am using user authentication for OAuth Mechanism.
I can query this table in Big Query web user interface and in R, and I can load other non-GS tables via ODBC in Stata. I think I need to give Stata/Simba/iodbc permission in https://myaccount.google.com/permissions (like BQ Client Tools and bigquery R has), but I am not sure how to do that or even that it necessary.
I would love to know what I am missing here.
Cross-posted here.
Comment