connections icon indicating copy to clipboard operation
connections copied to clipboard

bigrquery() dataset specification

Open tchaithonov opened this issue 4 years ago • 0 comments

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

tchaithonov avatar Dec 15 '20 19:12 tchaithonov