This method returns all partitions from Athena table.

dbGetPartition(conn, name, ..., .format = FALSE)

# S4 method for AthenaConnection
dbGetPartition(conn, name, ..., .format = FALSE)



A DBIConnection object, as returned by dbConnect().


A character string specifying a DBMS table name.


Other parameters passed on to methods.


re-formats AWS Athena partitions format. So that each column represents a partition from the AWS Athena table. Default set to FALSE to prevent breaking previous package behaviour.


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