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
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
bigrquerypackage 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