List Tables In A Spark Connection

Returns a list of tables/views in the current database. The result includes the name, database, description, table type and whether the table is temporary or not.

Usage

list_tables(sc, database = NULL)

Arguments

sc

A spark_connection.

database

character(1). The name of the database for which the functions should be listed (default: NULL).

Value

A tibble containing 5 columns:

• name - The name of the table.

• database - Name of the database the table belongs to.

• description - Description of the table.

• tableType - The type of table (e.g. view/table)

• isTemporary - Whether the table is temporary or not.

See also

cache_table(), create_table(), get_table(), refresh_table(), table_exists(), uncache_table()

Examples

if (FALSE) {
sc <- sparklyr::spark_connect(master = "local")
mtcars_spakr <- sparklyr::copy_to(dest = sc, df = mtcars)
list_tables(sc = sc)
}