I'm trying to connect bigquery to R in a Jupyter notebook. The notebook is on Google Vertex as a managed workbook. I followed the documentation that Google released on how to connect using R, but I keep running into the error below. I try following the link given and it tells me access denied. The issue is that I've enabled the Big Query API, Notebooks API, Vertex Ai API, BigQuery Connection API, and BigQuery Data Transfer API. As far as IAM permissions, I am a BigQuery Admin Vertex AI Admin, and BigQuery connection Admin. I have triple checked that I am in the appropriate project and I have the resourcemanager.projects.get general permission. I'm not sure where I am going wrong, but I keep getting this error every time. I have tried looking in the documentation for bigrquery and I still can't figure out the issue. Any help would be greatly appreciated!
Error in signal_reason():
! BigQuery API has not been used in project XXXX before or it is disabled. Enable it by visiting https://console.developers.google.com/apis/api/bigquery.googleapis.com/overview?project=XXXX then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry. [accessNotConfigured]
Traceback:
- bq_project_query(billing, sql)
- bq_perform_query(query, billing = x, destination_table = destination_table, . ...)
- bq_post(url, body = bq_body(body, ...), query = list(fields = "jobReference"))
- process_request(req)
- bq_check_response(status, type, content)
- signal_reason(json$error$errors[[1L]]$reason, json$error$message)
- rlang::abort(message, class = paste0("bigrquery_", reason))
- signal_abort(cnd, .file)
