Connect to ODBC Compatible Databases (using the DBI Interface)


[Up] [Top]

Documentation for package ‘odbc’ version 1.5.0

Help Pages

databricks Helper for Connecting to Databricks via ODBC
DatabricksOdbcDriver-class Helper for Connecting to Databricks via ODBC
dbAppendTable-method Convenience functions for reading/writing DBMS tables
dbConnect Connect to a database via an ODBC driver
dbConnect-method Helper for Connecting to Databricks via ODBC
dbConnect-method Connect to a database via an ODBC driver
dbConnect-method Helper for connecting to Snowflake via ODBC
dbExistsTableForWrite-method Connecting to Snowflake via ODBC
DBI-tables Convenience functions for reading/writing DBMS tables
dbListTables-method List remote tables and fields for an ODBC connection
dbWriteTable-method Convenience functions for reading/writing DBMS tables
isTempTable Helper method used to determine if a table identifier is that of a temporary table.
isTempTable-method Helper method used to determine if a table identifier is that of a temporary table.
odbc Connect to a database via an ODBC driver
odbcConnectionColumns_-method Connecting to Snowflake via ODBC
odbcDataType Return the corresponding ODBC data type for an R object
odbcDataType-method Return the corresponding ODBC data type for an R object
odbcListColumns List columns in an object.
odbcListConfig List locations of ODBC configuration files
odbcListDataSources List Configured Data Source Names
odbcListDrivers List Configured ODBC Drivers
odbcListObjects List objects in a connection.
odbcListObjectTypes Return the object hierarchy supported by a connection.
odbcPreviewObject Preview the data in an object.
odbcSetTransactionIsolationLevel Set the Transaction Isolation Level for a Connection
quote_value Quote special character when connecting
snowflake Helper for connecting to Snowflake via ODBC
sqlCreateTable-method Convenience functions for reading/writing DBMS tables