odbc

odbc copied to clipboard

simonpcouch

hadley

Enumerate procedures / functions in connections pane ( in addition to tables/views ), if possible.

detule

This is an attempt at finishing off https://github.com/r-dbi/odbc/pull/461 * Rebased on top of main * Rather than customizing both `dbListTables` and `dbExistsTable`, opted to specialize `odbcConnectionTables`. I think this resulted...

detule

Allow `uid` to be specified when using `authenticator="externalbrowser"`

2

For our Snowflake instance we have external auth set up, but the connection string requires we pass our user name. Currently `odbc::snowflake()` does not allow you to pass `uid` without...

ray-pacheco

DBI::dbWriteTable fails when useNativeQuery = TRUE

1

I have a databricks odbc connection and I would like to use DBI::dbWriteTable. I think by default the driver is using the sql translation feature (useNativeQuery = TRUE). With this...

ablack3

Related to: https://github.com/r-dbi/odbc/issues/790 https://github.com/r-dbi/odbc/issues/208 https://github.com/r-dbi/odbc/issues/130 When writing to a datetime/datetime2 target, we use a fixed precision of three decimals to avoid needing to know the user-configurable precision of the datetime2...

detule

simonpcouch

Now that we have some macOS-specific functionality, it may be worth putting together a `db-macos.yml` GHA workflow running on `macOS-latest`. Just testing `databricks()` and `snowflake()`, for now, would cover our...

simonpcouch

Include synonyms in `odbcListObjects()`, `dbListTables()`, and the Connections Pane

1

The issue discussed in #773 for SQL Server also applies to Oracle. So here is a separate issue as suggested by @simonpcouch. In Oracle, synonyms are available in [{ALL|USER}_SYNONYMS](https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/USER_SYNONYMS.html). Same...

ThomasSoeiro