Currently returns the top n elements (rows) from result set or returns entire table from Athena.
# S4 method for AthenaResult
dbFetch(res, n = -1, ...)
An object inheriting from DBIResult, created by
dbSendQuery()
.
maximum number of records to retrieve per fetch. Use n = -1
or n = Inf
to retrieve all pending records.
Some implementations may recognize other special values. Currently chunk sizes range from 0 to 999,
if entire dataframe is required use n = -1
or n = Inf
.
Other arguments passed on to methods.
dbFetch()
returns a data frame.
if (FALSE) {
# Note:
# - Require AWS Account to run below example.
# - Different connection methods can be used please see `RAthena::dbConnect` documnentation
library(DBI)
# Demo connection to Athena using profile name
con <- dbConnect(RAthena::athena())
res <- dbSendQuery(con, "show databases")
dbFetch(res)
dbClearResult(res)
# Disconnect from Athena
dbDisconnect(con)
}