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!
