odbc
odbc copied to clipboard
r-dbi
Connect to ODBC databases (using the DBI interface)
Without setting `EnableQueryResultDownload='0'` in the Databricks connection string, queries of > ~40k rows will return no data and a relatively cryptic error message: > [Simba][Hardy] (35) Error from server: error...
This commit expands the `databricks()` and `snowflake()` helpers to support the viewer-based OAuth credentials [recently introduced in Posit Connect][0]. It is designed to support writing Shiny apps that take the...
This closes https://github.com/r-dbi/odbc/issues/834. Some history: * In https://github.com/r-dbi/odbc/pull/531 we made it so that we use the same "output encoder" to convert both the column contents as well as the column...
We have been expriencing encoding problems with odbc 1.5.0 on SQL server. This works fine on odbc 1.4.2 All our databases unfortunately uses the varchar collation "Danish_Norwegian_CI_AS" - with odbc...
Currently, `odbc` [constructs a user-agent](https://github.com/r-dbi/odbc/blob/20de2e70362bd2336426a98191be92638ed44287/R/driver-databricks.R#L195) for Databricks connections if `SPARK_CONNECT_USER_AGENT` is not set. I think we should follow [the example](https://github.com/mlverse/pysparklyr/blob/39748e1b0bf1f6e9a82b490ccd1ec37d2ecef235/R/sparklyr-spark-connect.R#L228-L278) of `pysparklyr` and include additional details about the tool being...
