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

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