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(dplyr, lib.loc = "/opt/R/4.1.3/lib/R/library")
con <- dbConnect(
project = "biv-kti-b855",
dataset = "connectToRstudio"
However I get this error :
! Access Denied: Dataset biv-kti-b855:connectToRstudio: Permission bigquery.tables.list denied on dataset biv-kti-b855:connectToRstudio (or it may not exist). [accessDenied]
rlang::last_error()to see where the error occurred.
Can you help me please ?