Unity Catalog metastore list is showing empty

RamaTeja — Thu, 23 Feb 2023 08:02:24 GMT

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

Re: Unity Catalog metastore list is showing empty

RamaTeja — Fri, 24 Feb 2023 14:13:37 GMT

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.

Re: Unity Catalog metastore list is showing empty

PH_Wankhede — Tue, 24 Sep 2024 10:49:39 GMT

Same error, after creating new also getting empty list

topic Re: Unity Catalog metastore list is showing empty in Data Engineering

Unity Catalog metastore list is showing empty

Re: Unity Catalog metastore list is showing empty

Re: Unity Catalog metastore list is showing empty