Executes a statement to return the data description language (DDL) of the Athena table.

dbShow(conn, name, ...)

# S4 method for AthenaConnection
dbShow(conn, name, ...)

Arguments

conn

A DBIConnection object, as returned by dbConnect().

name

A character string specifying a DBMS table name.

...

Other parameters passed on to methods.

Value

dbShow() returns SQL characters of the Athena table DDL.

Examples

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 ddl RAthena::dbShow(con, "iris") # disconnect from Athena dbDisconnect(con) }