Issue with UCX Assessment Installation via Automation Script - Schema Not Found Error

Sudheer2
New Contributor III

 

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