Retrieve results from a query — dbGetQuery

Returns the result of a query as a data frame. dbGetQuery() comes with a default implementation (which should work with most backends) that calls dbSendQuery(), then dbFetch(), ensuring that the result is always freed by dbClearResult(). For retrieving chunked/paged results or for passing query parameters, see dbSendQuery(), in particular the "The data retrieval flow" section. For retrieving results as an Arrow object, see dbGetQueryArrow(). 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. AzureKusto::dbGetQuery("AzureKustoConnection", "character") DatabaseConnector::dbGetQuery("DatabaseConnectorConnection", "character") dittodb::dbGetQuery("DBIMockRPostgreSQLConnection", "character") implyr::dbGetQuery("src_impala", "character") odbc::dbGetQuery("OdbcConnection", "character") pool::dbGetQuery("Pool", "ANY") RAthena::dbGetQuery("AthenaConnection", "character") RH2::dbGetQuery("H2Connection", "character") RJDBC::dbGetQuery("JDBCConnection", "character") RPostgreSQL::dbGetQuery("PostgreSQLConnection", "character") RPresto::dbGetQuery("PrestoConnection", "character") sparklyr::dbGetQuery("spark_connection", "ANY")