DBI methods

odbc() dbConnect(<OdbcDriver>)

Connect to a database via an ODBC driver

dbListTables(<OdbcConnection>)

List remote tables and fields for an ODBC connection

dbWriteTable(<OdbcConnection>,<character>,<data.frame>) dbWriteTable(<OdbcConnection>,<Id>,<data.frame>) dbWriteTable(<OdbcConnection>,<SQL>,<data.frame>) dbAppendTable(<OdbcConnection>) sqlCreateTable(<OdbcConnection>)

Convenience functions for reading/writing DBMS tables

Database-specific helpers

databricks() dbConnect(<DatabricksOdbcDriver>)

Helper for Connecting to Databricks via ODBC

Microsoft SQL Server-class dbUnquoteIdentifier,Microsoft SQL Server,SQL-method isTempTable,Microsoft SQL Server,character-method isTempTable,Microsoft SQL Server,SQL-method dbExistsTable,Microsoft SQL Server,character-method dbListTables,Microsoft SQL Server-method dbExistsTable,Microsoft SQL Server,Id-method dbExistsTable,Microsoft SQL Server,SQL-method odbcConnectionSchemas,Microsoft SQL Server-method sqlCreateTable,Microsoft SQL Server-method odbcConnectionColumns_,Microsoft SQL Server,character-method odbcConnectionColumns_,Microsoft SQL Server,SQL-method

SQL Server

sqlCreateTable(<Oracle>) odbcConnectionTables(<Oracle>,<character>)

Oracle

redshift() dbConnect(<RedshiftOdbcDriver>)

Helper for Connecting to Redshift via ODBC

snowflake() dbConnect(<SnowflakeOdbcDriver>)

Helper for connecting to Snowflake via ODBC

ODBC configuration

odbc() dbConnect(<OdbcDriver>)

Connect to a database via an ODBC driver

dbExistsTableForWrite(<Snowflake>,<character>)

Connecting to Snowflake via ODBC

odbcDataType()

Return the corresponding ODBC data type for an R object

odbcListColumns()

List columns in an object.

odbcListConfig() odbcEditDrivers() odbcEditSystemDSN() odbcEditUserDSN()

List locations of ODBC configuration files

odbcListDataSources()

List Configured Data Source Names

odbcListDrivers()

List Configured ODBC Drivers

odbcListObjectTypes()

Return the object hierarchy supported by a connection.

odbcListObjects()

List objects in a connection.

odbcPreviewObject()

Preview the data in an object.

odbcSetTransactionIsolationLevel()

Set the Transaction Isolation Level for a Connection

isTempTable()

Helper method used to determine if a table identifier is that of a temporary table.

quote_value()

Quote special character when connecting