hms_credentials.md

copyright	lastupdated	keywords	subcollection
years 2022, 2024	2024-12-11	watsonx.data, spark, analytics, configuring	watsonxdata

{{site.data.keyword.attribute-definition-list}}

Retrieving Metadata Service (MDS) endpoints and credentials

{: #hms}

{{site.data.keyword.lakehouse_full}} integrates with multiple entities like Spark, Db2, {{site.data.keyword.netezza_short}}, and the like. You require {{site.data.keyword.lakehouse_short}} MDS credentials and enpoint to establish connection with the entities at the time of integration. {: shortdesc}

MDS username is by default ibmlhapikey.

Generating API key

{: #hms_api}

1. As the {{site.data.keyword.lakehouse_short}} administrator, you can:

   1. Create service IDs
   2. Invite users and grant permissions

   Permission required for {{site.data.keyword.lakehouse_short}} are MetastoreAdmin in Service access and appropriate roles in Platform access. {: note}

2. Generate an API key. for more information, see:

   • Creating an API key for users or user groups
   • Creating an API key for a service ID

Getting the MDS endpoint

{: #hms_url}

1. Log in to {{site.data.keyword.lakehouse_short}} console.

2. From the navigation menu, select Infrastructure manager.

3. Select the catalog.

4. Click Details to view the catalog details page.

5. Copy the endpoint:

   1. Metastore Thrift endpoint: This is your Hive interface endpoint for thrift.
   2. Metastore REST endpoint: Use this for Unity and Iceberg Catalog REST API.

   You can retrieve the endpoints using API. For more information, see Get catalog API.