LIST ENTITIES
Syntax
Description
This command creates a new Entity supported by a Store. These Entities can then be used to host Relations created through DDL or Query.
This command lists Entities that are present under the entity name specified by fully_qualified_entity_name
. If fully_qualified_entity_name
is not provided, the Entities under the root namespace are returned.
Entities will only be listed if the current role has USAGE privileges on the Store.
Arguments
IN fully_qualified_entity_name
Optionally, this lists Entities under the provided entity name. Otherwise, the root Entities are returned.
Examples
List Snowflake databases
List Snowflake schemas in a database
List Snowflake tables in a schema
List Databricks catalogs
List Databricks schemas in a catalog
List Databricks tables in a schema
List schemas in a Postgresql store
List Postgresql tables in a schema
Last updated