SET_EXT_METASTORE_PROPERTY stored procedure

The SYSHADOOP. SET_EXT_METASTORE_PROPERTY stored procedure sets, updates, or unsets a configuration property for a registered external metastore.

Authorization

EXECUTE is granted to the DASHDB_ENTERPRISE_ADMIN role.

Syntax

Read syntax diagramSkip visual syntax diagramSET_EXT_METASTORE_PROPERTY('external-metastore-name' ,'property-name','property-value','status-code','status-message')

The schema is SYSHADOOP.

Description

'external-metastore-name'
An input argument of type VARCHAR(256) indicating the name of the registered external metastore whose configuration property is to be set, updated, or unset.
'property-name'
An input argument of type VARCHAR(256) indicating the name of the configuration property to set, update, or unset. For a list of supported properties, see the Table 1 table below.
'property-value'
An input argument of type VARCHAR(1024) indicating the value of the configuration property. If the value is NULL, the property is unset. Otherwise, it is either set or updated with the value.
'status-code'
An output argument of type INTEGER indicating whether the operation was successful. 0 indicates success, a non-zero value indicates an error.
'status-message'
An output argument of type VARCHAR(1024) indicating whether the operation was successful.

Supported properties

The following properties are supported:
Table 1. Supported properties
Name Required Description
type Yes The type of metastore to which you are connecting. Supported values are:
  • watsonx-data – for connecting to a watsonx.data metastore
uri Yes The URI of the metastore
use.SSL No "true" if the metastore requires an SSL connection
ssl.cert No The certificate to use to validate the SSL connection. Can be a PEM file name or a string representing the cert in the PEM format. It is not necessary to pass a certificate if the SSL connection is established using a certificate issued by a well-known CA such as DigiCert or "Let’s Encrypt".
auth.mode No If the metastore requires authentication, indicates the mode of authentication to use. The only supported value for now is "PLAIN".
auth.plain.credentials No If the metastore requires PLAIN authentication, provides the credentials as a string in the form "username:password". The password is stored securely in a software keystore.

Examples

Setting the use.SSL property of the registered metastore watsonxdata to true to indicate that the connection is to be encrypted using SSL.
CALL SYSHADOOP.SET_EXT_METASTORE_PROPERTY('watsonxdata', 'use.SSL', 'true', ?, ?)
Unsetting the use.SSL property of the registered metastore watsonxdata to indicate that the connection is not to be encrypted.
CALL SYSHADOOP.SET_EXT_METASTORE_PROPERTY('watsonxdata', 'use.SSL', NULL, ?, ?)