cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Unity Catalog metastore list is showing empty

RamaTeja
New Contributor II

Hi ,

I am not able to list the meta-stores in databricks cli using the below command :

databricks unity-catalog metastores list

{}

but when I tried databricks unity-catalog metastores get-summary I am able to get the meta-store info .

Can anyone help me why i am not able to list the meta-stores details even a meta store is assigned to the workspace

2 REPLIES 2

RamaTeja
New Contributor II

Hi @Kaniz Fatma​ , Unity catalog is enabled in my workspace and i have been assigned metastore admin and account admin also.

databricks unity-catalog metastores list --debug

HTTP debugging enabled

send: b'GET /api/2.1/unity-catalog/metastores HTTP/1.1\r\nHost: adb-xxxxxxxx.azuredatabricks.net\r\nuser-agent: databricks-cli-0.17.3-unity-catalog-metastores-list-xxxx-***-***\r\nAccept-Encoding: gzip, deflate\r\nAccept: */*\r\nConnection: keep-alive\r\nAuthorization: Bearer xxxxxx\r\nContent-Type: text/json\r\n\r\n'

reply: 'HTTP/1.1 200 OK\r\n'

header: date: Fri, 24 Feb 2023 14:06:48 GMT

header: strict-transport-security: max-age=31536000; includeSubDomains; preload

header: x-content-type-options: nosniff

header: content-type: application/json

header: x-databricks-org-id: xxxxxx

header: content-encoding: gzip

header: vary: Accept-Encoding

header: server: databricks

header: transfer-encoding: chunked

{}

databricks unity-catalog metastores get-summary --debug

HTTP debugging enabled

send: b'GET /api/2.1/unity-catalog/metastore_summary HTTP/1.1\r\nHost: adb-xxxxxx.azuredatabricks.net\r\nuser-agent: databricks-cli-0.17.3-unity-catalog-metastores-get-summary-xxxxxx\r\nAccept-Encoding: gzip, deflate\r\nAccept: */*\r\nConnection: keep-alive\r\nAuthorization: Bearer xxxxx\r\nContent-Type: text/json\r\n\r\n'

reply: 'HTTP/1.1 200 OK\r\n'

header: date: Fri, 24 Feb 2023 14:09:38 GMT

header: strict-transport-security: max-age=31536000; includeSubDomains; preload

header: x-content-type-options: nosniff

header: content-type: application/json

header: x-databricks-org-id: xxxxx

header: content-encoding: gzip

header: vary: Accept-Encoding

header: server: databricks

header: transfer-encoding: chunked

{

 "metastore_id": "xxxxxxx",

 "name": "meta-gmf-unity",

 "default_data_access_config_id": "xxxx",

 "storage_root_credential_id": "xxxxx",

 "cloud": "azure",

 "region": "xxxx",

 "global_metastore_id": "azure:xxxxxxxxx",

 "storage_root_credential_name": "storage-credentials-name",

 "privilege_model_version": "1.0",

 "delta_sharing_scope": "INTERNAL_AND_EXTERNAL",

 "delta_sharing_recipient_token_lifetime_in_seconds": 15552000,

 "storage_root": "abfss://xxxxx",

 "owner": "xxxxx",

 "created_at": 1675680181865,

 "created_by": "it@anblicks.com",

 "updated_at": 1677049113454,

 "updated_by": "xxxx"

}

For get summary command i am able to get metastore details then when i tried list command why am i not able to list the metastores there.

Same error, after creating new also getting empty list

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group