Learn R Programming

noctua (version 2.6.2)

dbListTables: List Athena Tables

Description

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

Usage

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

Value

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

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.

See Also

Examples

Run this code
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)
}

Run the code above in your browser using DataLab