topic Re: UCX V0.58.0 Dashboard in Databricks Showing 0 Tables Despite Existing Tables. in Warehousing & Analytics

UCX V0.58.0 Dashboard in Databricks Showing 0 Tables Despite Existing Tables.

meghana_tulla — Tue, 29 Apr 2025 13:00:50 GMT

Hi,

I am currently installing UCX version 0.58.0 in Non-Unity enabled Databricks Workspace. It installed successfully and the job completes without errors. However, The Dashboard that goanna generate showing "0 Total Tables" and other metrics as 0.

Has anyone encountered this issue with UCXv0.58.0? Is there any known bug or misconfiguration that causes the dashboard counts to return 0?

Thank You.

Re: UCX V0.58.0 Dashboard in Databricks Showing 0 Tables Despite Existing Tables.

RiyazAliM — Wed, 30 Apr 2025 10:06:40 GMT

Hi @meghana_tulla

Can you check for UCX job logs? Look for table scanning if it skipped or fails silently.
Alternatively, try UCX v0.57.0 which is known to work better with non-Unity environments.

Thanks,

Re: UCX V0.58.0 Dashboard in Databricks Showing 0 Tables Despite Existing Tables.

meghana_tulla — Fri, 02 May 2025 07:48:34 GMT

Hi aaryrm,

I have installed UCX v0.57.0, but I am getting a total count of 0 for both tables and views, even though the installation job ran successfully.

Would you like help troubleshooting why the counts are showing as zero?

Re: UCX V0.58.0 Dashboard in Databricks Showing 0 Tables Despite Existing Tables.

RiyazAliM — Fri, 02 May 2025 09:27:01 GMT

Hi @meghana_tulla

Have you had a chance to check the UCX Logs? You can also share the logs here and share the screenshot of the job details along with the dashboard.

Thanks,

Re: UCX V0.58.0 Dashboard in Databricks Showing 0 Tables Despite Existing Tables.

meghana_tulla — Fri, 02 May 2025 10:41:28 GMT

can u help me this for this job

assess_dashboards run
WARN [d.l.u.assessment.dashboards] Error when parsing Lakeview dashboard: : Traceback (most recent call last): File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/ucx/assessment/dashboards.py", line 304, in _convert_sdk_to_lsql_lakeview_dashboard lsql_dashboard = LsqlLakeviewDashboard.from_dict(json.loads(dashboard.serialized_dashboard)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/lsql/lakeview/model.py", line 588, in from_dict return cls(datasets=_repeated_dict(d, "datasets", Dataset), pages=_repeated_dict(d, "pages", Page)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 16, in _repeated_dict return [from_dict(v) for v in d[field]] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 16, in <listcomp> return [from_dict(v) for v in d[field]] ^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/lsql/lakeview/model.py", line 1108, in from_dict layout=_repeated_dict(d, "layout", Layout), ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 16, in _repeated_dict return [from_dict(v) for v in d[field]] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 16, in <listcomp> return [from_dict(v) for v in d[field]] ^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/lsql/lakeview/model.py", line 874, in from_dict return cls(position=_from_dict(d, "position", Position), widget=_from_dict(d, "widget", Widget)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 9, in _from_dict return getattr(cls, 'from_dict')(d[field]) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/lsql/lakeview/model.py", line 1931, in from_dict spec=_from_dict(d, "spec", WidgetSpec), ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 9, in _from_dict return getattr(cls, 'from_dict')(d[field]) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/lsql/lakeview/model.py", line 130, in from_dict raise KeyError(f"unknown: version={d['version']} widgetType={d['widgetType']}") KeyError: 'unknown: version=3 widgetType=histogram' 09:45:37 INFO [d.l.u.s.linters.queries] Linting dashboard: dashboard_01 () 09:45:38 INFO [d.l.u.s.linters.queries] Saving 0 linting problems...

Re: UCX V0.58.0 Dashboard in Databricks Showing 0 Tables Despite Existing Tables.

meghana_tulla — Wed, 07 May 2025 08:28:36 GMT

Hi,

Still facing the same issue actually, I am trying to automate the UCX installation using bashscript. while running the bashscript the job starts and run successfully with all run jobs. Even all jobs Ran successfully, I am getting 0 tables and 0 values in the dashboard.

The jobs are not showing any error.