RAthena (version 1.7.0)

dbGetInfo: Get DBMS metadata

Description

Get DBMS metadata

Usage

# S4 method for AthenaConnection
dbGetInfo(dbObj, ...)
# S4 method for 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

dbGetInfo

Examples

# NOT RUN {
# 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())
                 
# 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)
# }