RAthena (version 1.7.0)

dbGetQuery: Send query, retrieve results and then clear result set

Description

Send query, retrieve results and then clear result set

Usage

# S4 method for AthenaConnection,character
dbGetQuery(conn, statement = NULL, ...)

Arguments

conn

A '>DBIConnection object, as returned by dbConnect().

statement

a character string containing SQL.

...

Other parameters passed on to methods.

Value

dbGetQuery() returns a dataframe.

See Also

dbGetQuery

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())

# Sending Queries to Athena
dbGetQuery(con, "show databases")

# Disconnect conenction
dbDisconnect(con)
# }