Issue: UCX Assessment Installation Error in Databricks Automation Script

meghana_tulla
Databricks Partner

‎05-23-2025 06:12 AM

Hi 

I'm experiencing a problem when installing UCX Assessment through an automation script in Databricks. The script fails with this error:

13:38:06 WARNING [databricks.labs.ucx.hive_metastore.tables] {listing_tables_0} failed-table-crawl: listing tables from database -> ALL : [SCHEMA_NOT_FOUND] The schema `ALL` cannot be found. Verify the spelling and correctness of the schema and catalog.

What Works: When I install manually using:

bash
databricks labs install ucx@v0.57.0

The installation prompts me for:

  • Comma-separated list of workspace group names to migrate (default: <ALL>)
  • Comma-separated list of databases to migrate (default: <ALL>)

Using the default <ALL> values works perfectly - no errors occur and the UCX dashboard populates correctly.

What Doesn't Work: In my automation script, I'm explicitly setting:

bash
WORKSPACE_GROUPS="<ALL>" DATABASES="<ALL>"

Despite using the same <ALL> values, I get the schema not found error.

#UCX #Assessment #Databricks

Questions:

1.Why does the manual installation work with <ALL> but the automated script fails?

2.Are there additional parameters I need to configure for automation?

3.How can I resolve this schema lookup issue in the automation script?

4.Any insights or solutions would be greatly appreciated!

 

0 Kudos