| AthenaConnection | R Documentation |
Implementations of pure virtual functions defined in the DBI package
for AthenaConnection objects.
Method to get Athena schema, tables and table types return as a data.frame
This method returns all partitions from Athena table.
Executes a statement to return the data description language (DDL) of the Athena table.
## S4 method for signature 'AthenaConnection'
show(object)
## S4 method for signature 'AthenaConnection'
dbDisconnect(conn, ...)
## S4 method for signature 'AthenaConnection'
dbIsValid(dbObj, ...)
## S4 method for signature 'AthenaConnection,character'
dbSendQuery(conn, statement, unload = athena_unload(), ...)
## S4 method for signature 'AthenaConnection,character'
dbSendStatement(conn, statement, unload = athena_unload(), ...)
## S4 method for signature 'AthenaConnection,character'
dbExecute(conn, statement, unload = athena_unload(), ...)
## S4 method for signature 'AthenaConnection,ANY'
dbDataType(dbObj, obj, ...)
## S4 method for signature 'AthenaConnection,data.frame'
dbDataType(dbObj, obj, ...)
## S4 method for signature 'AthenaConnection,character'
dbQuoteString(conn, x, ...)
## S4 method for signature 'AthenaConnection,POSIXct'
dbQuoteString(conn, x, ...)
## S4 method for signature 'AthenaConnection,Date'
dbQuoteString(conn, x, ...)
## S4 method for signature 'AthenaConnection,SQL'
dbQuoteIdentifier(conn, x, ...)
dbGetTables(conn, ...)
## S4 method for signature 'AthenaConnection'
dbGetTables(conn, catalog = NULL, schema = NULL, ...)
## S4 method for signature 'AthenaConnection,character'
dbListFields(conn, name, ...)
## S4 method for signature 'AthenaConnection,character'
dbExistsTable(conn, name, ...)
## S4 method for signature 'AthenaConnection,Id'
dbExistsTable(conn, name, ...)
## S4 method for signature 'AthenaConnection,character'
dbRemoveTable(conn, name, delete_data = TRUE, confirm = FALSE, ...)
## S4 method for signature 'AthenaConnection,Id'
dbRemoveTable(conn, name, delete_data = TRUE, confirm = FALSE, ...)
## S4 method for signature 'AthenaConnection,character'
dbGetQuery(conn, statement, statistics = FALSE, unload = athena_unload(), ...)
## S4 method for signature 'AthenaConnection'
dbGetInfo(dbObj, ...)
dbGetPartition(conn, name, ..., .format = FALSE)
## S4 method for signature 'AthenaConnection'
dbGetPartition(conn, name, ..., .format = FALSE)
dbShow(conn, name, ...)
## S4 method for signature 'AthenaConnection'
dbShow(conn, name, ...)
## S4 method for signature 'AthenaConnection'
dbBegin(conn, ...)
## S4 method for signature 'AthenaConnection'
dbCommit(conn, ...)
## S4 method for signature 'AthenaConnection'
dbRollback(conn, ...)
object |
Any R object |
conn |
A DBI::DBIConnection object, as returned by dbConnect(). |
... |
Other parameters passed on to methods. |
dbObj |
An object inheriting from |
statement |
a character string containing SQL. |
unload |
boolean input to modify |
obj |
An R object whose SQL type we want to determine. |
x |
A character vector to quote as string. |
catalog |
Athena catalog, default set to NULL to return all tables from all Athena catalogs |
schema |
Athena schema, default set to NULL to return all tables from all Athena schemas. Note: The use of DATABASE and SCHEMA is interchangeable within Athena. |
name |
The table name, passed on to
|
delete_data |
Deletes S3 files linking to AWS Athena table |
confirm |
Allows for S3 files to be deleted without the prompt check. It is recommend to leave this set to |
statistics |
If set to |
.format |
re-formats AWS Athena partitions format. So that each column represents a partition
from the AWS Athena table. Default set to |
dbGetTables() returns a data.frame.
data.frame that returns all partitions in table, if no partitions in Athena table then function will return error from Athena.
dbShow() returns SQL characters of the Athena table DDL.
ptra list of connecting objects from the SDK paws package.
infoa list of metadata objects
quotesyntax to quote sql query when creating Athena ddl
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.