Permission acces to my tables are denied on my BigQuery dataset

General
, , ,
1

Hello to all,

I am currently trying to retrieve the contents of my BigQuery dataset through Rstudio.

I tried to connect to my dataset and then display the list of tables it contains with the following R script:

install.packages("bigrquery", repos = c(CRAN = "https://packagemanager.rstudio.com/all/__linux__/bionic/latest") )

install.packages("dplyr", repos = c(CRAN = "https://packagemanager.rstudio.com/all/__linux__/bionic/latest") )

library(bigrquery)

library(dplyr, lib.loc = "/opt/R/4.1.3/lib/R/library")

con <- dbConnect(
bigrquery::bigquery(),
project = "biv-kti-b855",
dataset = "connectToRstudio"
)

dbListTables(con)

However I get this error :

Error in signal_reason():
! Access Denied: Dataset biv-kti-b855:connectToRstudio: Permission bigquery.tables.list denied on dataset biv-kti-b855:connectToRstudio (or it may not exist). [accessDenied]
Run rlang::last_error() to see where the error occurred.

Can you help me please ?

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.