dbGetPartition {RAthena} | R Documentation |
Athena table partitions
Description
This method returns all partitions from Athena table.
Usage
dbGetPartition(conn, name, ..., .format = FALSE)
## S4 method for signature 'AthenaConnection'
dbGetPartition(conn, name, ..., .format = FALSE)
Arguments
conn |
A DBIConnection object, as returned by
|
name |
The table name, passed on to
|
... |
Other parameters passed on to methods. |
.format |
re-formats AWS Athena partitions format. So that each column represents a partition
from the AWS Athena table. Default set to |
Value
data.frame that returns all partitions in table, if no partitions in Athena table then function will return error from Athena.
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())
# write iris table to Athena
dbWriteTable(con, "iris",
iris,
partition = c("timestamp" = format(Sys.Date(), "%Y%m%d")),
s3.location = "s3://path/to/store/athena/table/"
)
# return table partitions
RAthena::dbGetPartition(con, "iris")
# disconnect from Athena
dbDisconnect(con)
## End(Not run)