Returns the unquoted names of Athena tables accessible through this connection.
# S4 method for class 'AthenaConnection'
dbListTables(conn, catalog = NULL, schema = NULL, ...)
A DBI::DBIConnection object, as returned by dbConnect().
Athena catalog, default set to NULL to return all tables from all Athena catalogs
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.
Other parameters passed on to methods.
dbListTables()
returns a character vector with all the tables from Athena.
if (FALSE) { # \dontrun{
# Note:
# - Require AWS Account to run below example.
# - Different connection methods can be used please see `noctua::dbConnect` documnentation
library(DBI)
# Demo connection to Athena using profile name
con <- dbConnect(noctua::athena())
# Return list of tables in Athena
dbListTables(con)
# Disconnect conenction
dbDisconnect(con)
} # }