Connecting to watsonx.data on IBM Cloud or Amazon Web Services

To connect to the watsonx.data metastore, its URI is required and must be provided through the uri property.

The URI scheme must be thrift:// and the hostname and port number can be obtained from the watsonx.data Infrastructure Manager screen, by clicking on the catalog you want to connect to and copy the value labelled Metastore host on the page.

The connection to the metastore server of watsonx.data instances running on IBM Cloud or Amazon Web Services is secured with SSL/TLS using a certificate provided by a well-known Certificate Authority. It is therefore required to indicate that the connection uses ssl (set the use.SSL property to true), but there is no need to provider a certificate.

The connection is authenticated using PLAIN authentication. This must be indicated by setting the auth.mode property to PLAIN, and requires to provide a user name and password through the auth.plain.credentials property.

The credentials must be created on the watsonx.data deployment by an administrator in the following way:
  • The user name must be a service ID named ibmlhapikey created for this purpose for the watsonx.data service. For more information on creating service IDs, see Creating and working with service IDs.
  • The service ID must be assigned the Administrator and Metastore Access roles.
  • The password must be an API key generated for the service ID. For more information, see Managing service ID API keys.