This method returns all partitions from Athena table.
dbGetPartition(conn, name, ..., .format = FALSE) # S4 method for AthenaConnection dbGetPartition(conn, name, ..., .format = FALSE)
conn | A DBIConnection object, as returned by
|
---|---|
name | A character string specifying a DBMS table name. |
... | 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 |
data.frame that returns all partitions in table, if no partitions in Athena table then function will return error from Athena.
if (FALSE) { # 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) }