Hello,
I'm encountering an issue while installing UCX Assessment via an automation script in Databricks. When running the script, I get the following 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.
However, when I run the same installation manually with the command:
databricks labs install ucx@v0.57.0
I’m prompted to specify the following parameters:
Comma-separated list of workspace group names to migrate (default: <ALL>)
Comma-separated list of databases to migrate (default: <ALL>)
When I use the default <ALL> values during the manual installation, the process works without any errors, and the UCX dashboard populates correctly.
In my automation script, I am explicitly setting the following configuration:
WORKSPACE_GROUPS="<ALL>" DATABASES="<ALL>"
Despite this, I still get the error: [SCHEMA_NOT_FOUND] The schema 'ALL' cannot be found.
Could anyone provide insight into why this is happening or how I can resolve this issue in the automation script? Is there any other parameter I need to adjust to make sure the installation runs correctly in the script?
Thanks in advance!
#UCX #Assessment #databricks