List Athena Tables — dbListTables • noctua

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