EXT_METASTORE_PROPERTIES stored procedure

The SYSHADOOP. EXT_METASTORE_PROPERTIES stored procedure returns a dynamic result set listing the configuration properties associated with a registered external metastore.

Authorization

EXECUTE is granted to the DASHDB_ENTERPRISE_ADMIN role.

Syntax

Read syntax diagramSkip visual syntax diagramEXT_METASTORE_PROPERTIES('external-metastore-name' )

The schema is SYSHADOOP.

Description

'external-metastore-name'
An input argument of type VARCHAR(256) containing the name of the registered metastore whose configuration properties are to be returned. If NULL, configuration properties for all of the registered metastores is returned.

Examples

CALL SYSHADOOP.EXT_METASTORE_PROPERTIES('watsonxdata')