Returns the unquoted names of Athena tables accessible through this connection.

# S4 method for AthenaConnection
dbListTables(conn, catalog = NULL, schema = NULL, ...)

Arguments

conn

A DBIConnection object, as returned by dbConnect().

catalog

Athena catalog, default set to NULL to return all tables from all Athena catalogs

schema

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.

Value

dbListTables() returns a character vector with all the tables from Athena.

See also

Examples

if (FALSE) {
# 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)
}