Adam Black
Adam Black
`dbHasCompleted` returns FALSE even though all rows have been fetched from a result object. ``` r library(bigrquery) library(DBI) bq_auth(path = Sys.getenv("BIGQUERY_SERVICE_ACCOUNT_JSON_PATH")) con [1] 50 # dbHasCompleted returns FALSE even though...
It looks like `bigquery` supports transactions but bigrquery does not currently support `dbWithTransation()`. I would like to be able to use DBI::dbWithTransaction with a `BigQueryConnection`. For some reason the code...
Is it possible to use visdat with a database table (referenced by a tbl_dbi object in R)?
Would it be possible to disconnect and later reconnect a dm object to/from a remote database? I'd like to pass a disconnected dm object into a function, have it open...
I would like to list tables in a specific schema using `dbListTables` and use syntax that will work with other DBI backends that support listing tables in a schema (e.g....
Thank you very much for adding Date support in RSQLite! RSQLite support Date typed columns when tables are created using SQL. However when tables are created from dataframes using dbWriteTable...
This is an issue for the 2022 Hades Hack-a-thon. Hades requirements: https://ohdsi.github.io/Hades/packageRequirements.html
I would like to create a fileSystemDataset object in a temp folder, process it in batches, and then remove it. This works fine on Linux and Mac but on Windows...
SqlRender::translate seems to map table names to lower case when translating to bigquery. This is problematic if table names are uppercase in the database since bigquery is case sensitive. It's...
SqlRender performs substitution on strings of text but does not guarantee that its output will actually run on the desired dbms. This is because it does not check that it's...