list_tables: List Tables In A Spark Connection

In catalog: Access the 'Spark Catalog' API via 'sparklyr'

List Tables In A Spark Connection

Description

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

## Not run: 
sc <- sparklyr::spark_connect(master = "local")
mtcars_spakr <- sparklyr::copy_to(dest = sc, df = mtcars)
list_tables(sc = sc)

## End(Not run)

catalog documentation built on Aug. 23, 2022, 1:07 a.m.