cancel
Showing results for 
Search instead for 
Did you mean: 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 REPLIES 0

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now