Create a connection to a DBMS — dbConnect

Connect to a DBMS going through the appropriate authentication procedure. Some implementations may allow you to have multiple connections open, so you may invoke this function repeatedly assigning its output to different objects. The authentication mechanism is left unspecified, so check the documentation of individual drivers for details. Use dbCanConnect() to check if a connection can be established. Methods in other packagesThis documentation page describes the generics. Refer to the documentation pages linked below for the documentation for the methods that are implemented in various backend packages. adbi::dbConnect("AdbiDriver") AzureKusto::dbConnect("AzureKustoDriver") bigrquery::dbConnect("BigQueryDriver") bigrquery::dbConnect("bq_dataset") DatabaseConnector::dbConnect("DatabaseConnectorDriver") duckdb::dbConnect("duckdb_driver") lazysf::dbConnect("SFSQLDriver") odbc::dbConnect("DatabricksOdbcDriver") odbc::dbConnect("OdbcDriver") RAthena::dbConnect("AthenaDriver") RH2::dbConnect("H2Driver") RJDBC::dbConnect("JDBCDriver") RMariaDB::dbConnect("MariaDBDriver") RMySQL::dbConnect("MySQLConnection") RMySQL::dbConnect("MySQLDriver") RPostgres::dbConnect("PqDriver") RPostgres::dbConnect("RedshiftDriver") RPostgreSQL::dbConnect("character") RPostgreSQL::dbConnect("PostgreSQLConnection") RPostgreSQL::dbConnect("PostgreSQLDriver") RPresto::dbConnect("PrestoDriver") RSQLite::dbConnect("SQLiteConnection") RSQLite::dbConnect("SQLiteDriver") sergeant::dbConnect("DrillDriver")