dbGetInfo {noctua} | R Documentation |
Get DBMS metadata
Description
Get DBMS metadata
Usage
## S4 method for signature 'AthenaConnection'
dbGetInfo(dbObj, ...)
## S4 method for signature 'AthenaResult'
dbGetInfo(dbObj, ...)
Arguments
dbObj |
An object inheriting from DBIObject, i.e. DBIDriver, DBIConnection, or a DBIResult |
... |
Other arguments to methods. |
Value
a named list
See Also
Examples
## Not run:
# Note:
# - Require AWS Account to run below example.
# - Different connection methods can be used please see `noctua::dbConnect` documnentation
library(DBI)
# Demo connection to Athena using profile name
con <- dbConnect(noctua::athena())
# Returns metadata from connnection object
metadata <- dbGetInfo(con)
# Return metadata from Athena query object
res <- dbSendQuery(con, "show databases")
dbGetInfo(res)
# Clear result
dbClearResult(res)
# disconnect from Athena
dbDisconnect(con)
## End(Not run)
[Package noctua version 2.6.2 Index]