connections
connections copied to clipboard
bigrquery() dataset specification
Hi,
Great package! Recently started exploring this and find it useful when working with multiple different datasets located on different platforms (BGQ, Redshift, Postgres, etc.).
A question in relation to BGQ. In the bigrquery package these days (2.0.0 and beyond), I can do without specifying a dataset to connect to. All I need to do is to put down the dataset name when connecting the tables:
tbl_a <- con %>% tbl("dataset_a.table_a")
It looks like connection_open() right now is forcing me to choose. Since I have many datasets within a BGQ project, is there a way to do without specifying 10 connections for 10 different datasets within the same project?
Thanks for your time. T