Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

The last step during assessment assessment_report fails with two queries failing with the same error UNRESOLVED_COLUMN.WITH_SUGGESTION:

Expected Behavior

The queries complete without errors.

Steps To Reproduce

The issue is that the query is using a column alias - which usually happens at a later stage in the query. The DBSQL parser tries to handle this implicitly, but for some setups this fails. The fix is to replace the alias format with the actual column name table_format in these two locations.

https://github.com/databrickslabs/ucx/blob/main/src/databricks/labs/ucx/queries/assessment/main/05_0_all_tables.sql
https://github.com/databrickslabs/ucx/blob/main/src/databricks/labs/ucx/queries/assessment/main/03_0_database_summary.sql#L21

Cloud

AWS

Operating System

macOS

Version

latest via Databricks CLI

Relevant log output

No response