Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Adding flag to Job to identify Job submitted by jar #1088

Merged
merged 12 commits into from
Mar 27, 2024

Conversation

prajin-29
Copy link
Contributor

@prajin-29 prajin-29 commented Mar 22, 2024

Changes

Adding flag to Job Table to identify Job submitted by jar

Linked issues

Closes #765

@prajin-29
Copy link
Contributor Author

image Added a flag to see if the job and task with jar type.

Copy link

codecov bot commented Mar 22, 2024

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 88.87%. Comparing base (eb50f9a) to head (066e19c).

Additional details and impacted files
@@            Coverage Diff             @@
##             main    #1088      +/-   ##
==========================================
+ Coverage   88.83%   88.87%   +0.04%     
==========================================
  Files          65       65              
  Lines        7174     7183       +9     
  Branches     1290     1293       +3     
==========================================
+ Hits         6373     6384      +11     
+ Misses        534      532       -2     
  Partials      267      267              

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

Copy link
Collaborator

@nfx nfx left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

append to failures array, that way you don't need to modify queries at all and there's no breaking change. make sure that SubmitRunsCrawler picks this check as well.

@@ -34,6 +34,7 @@ class JobInfo:
job_id: str
success: int
failures: str
has_jar_task: int
Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

don't add new fields to this table - it's a breaking change and every breaking change has to be justified.

rewrite it as addition to failures array, so that it appears in the generic failures.

spark_jar_job = [task for task in job.settings.tasks if task.spark_jar_task is not None]
else:
spark_jar_job = None
jar_fg = 1 if spark_jar_job else 0
Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

do this logic the way it's reusable in JobsCrawler and SubmitRunsCrawler. Probably in JobsMixin.

@nfx nfx added the step/assessment go/uc/upgrade - Assessment Step label Mar 23, 2024
@prajin-29
Copy link
Contributor Author

@nfx .Rewritten the code to capture the jar task in failures

Copy link
Collaborator

@nfx nfx left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Lgtm

tests/unit/assessment/test_jobs.py Outdated Show resolved Hide resolved
@nfx nfx marked this pull request as ready for review March 27, 2024 07:40
@nfx nfx requested review from a team and larsgeorge-db March 27, 2024 07:40
Copy link

github-actions bot commented Mar 27, 2024

❌ 110/114 passed, 3 flaky, 4 failed, 20 skipped, 1h45m2s total

❌ test_migrate_external_table: databricks.labs.blueprint.parallel.ManyError: Detected 1 failures: BadRequest: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration. (12.36s)
databricks.labs.blueprint.parallel.ManyError: Detected 1 failures: BadRequest: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
08:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_svdcd: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svdcd
08:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_svdcd', metastore_id=None, name='ucx_svdcd', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw5] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
08:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_svdcd: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svdcd
08:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_svdcd', metastore_id=None, name='ucx_svdcd', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_szuum: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_szuum
08:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_szuum', metastore_id=None, name='ucx_szuum', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/Wuue
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_szuum.ucx_t09pw: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_szuum/ucx_t09pw
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_szuum.ucx_t09pw', metastore_id=None, name='ucx_t09pw', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_szuum', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/Wuue', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1711527361636, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6iwm', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c6iwm', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1711527361636, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_c6iwm.ucx_szuum: https://DATABRICKS_HOST/explore/data/ucx_c6iwm/ucx_szuum
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c6iwm', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6iwm.ucx_szuum', metastore_id=None, name='ucx_szuum', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:16 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_c6iwm, external_table=hive_metastore.ucx_szuum.ucx_t09pw
08:16 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating external table hive_metastore.ucx_szuum.ucx_t09pw to using SQL query: SYNC TABLE ucx_c6iwm.ucx_szuum.ucx_t09pw FROM hive_metastore.ucx_szuum.ucx_t09pw;
08:16 ERROR [databricks.labs.blueprint.parallel] migrate tables task failed: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
Traceback (most recent call last):
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/blueprint/parallel.py", line 135, in inner
    return func(*args, **kwargs), None
  File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/table_migrate.py", line 111, in _migrate_table
    return self._migrate_external_table(src_table, rule, grants)
  File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/table_migrate.py", line 128, in _migrate_external_table
    self._backend.execute(src_table.sql_alter_from(rule.as_uc_table_key, self._ws.get_workspace_id()))
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/backends.py", line 142, in execute
    self._sql.execute(sql)
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 238, in execute
    self._raise_if_needed(status)
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 473, in _raise_if_needed
    raise error_class(error_message)
databricks.sdk.errors.platform.BadRequest: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
08:16 CRITICAL [databricks.labs.blueprint.parallel] All 'migrate tables' tasks failed!!!
08:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_svdcd: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svdcd
08:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_svdcd', metastore_id=None, name='ucx_svdcd', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_szuum: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_szuum
08:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_szuum', metastore_id=None, name='ucx_szuum', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/Wuue
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_szuum.ucx_t09pw: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_szuum/ucx_t09pw
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_szuum.ucx_t09pw', metastore_id=None, name='ucx_t09pw', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_szuum', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/Wuue', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1711527361636, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6iwm', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c6iwm', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1711527361636, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_c6iwm.ucx_szuum: https://DATABRICKS_HOST/explore/data/ucx_c6iwm/ucx_szuum
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c6iwm', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6iwm.ucx_szuum', metastore_id=None, name='ucx_szuum', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:16 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_c6iwm, external_table=hive_metastore.ucx_szuum.ucx_t09pw
08:16 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating external table hive_metastore.ucx_szuum.ucx_t09pw to using SQL query: SYNC TABLE ucx_c6iwm.ucx_szuum.ucx_t09pw FROM hive_metastore.ucx_szuum.ucx_t09pw;
08:16 ERROR [databricks.labs.blueprint.parallel] migrate tables task failed: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
Traceback (most recent call last):
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/blueprint/parallel.py", line 135, in inner
    return func(*args, **kwargs), None
  File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/table_migrate.py", line 111, in _migrate_table
    return self._migrate_external_table(src_table, rule, grants)
  File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/table_migrate.py", line 128, in _migrate_external_table
    self._backend.execute(src_table.sql_alter_from(rule.as_uc_table_key, self._ws.get_workspace_id()))
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/backends.py", line 142, in execute
    self._sql.execute(sql)
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 238, in execute
    self._raise_if_needed(status)
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 473, in _raise_if_needed
    raise error_class(error_message)
databricks.sdk.errors.platform.BadRequest: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
08:16 CRITICAL [databricks.labs.blueprint.parallel] All 'migrate tables' tasks failed!!!
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/Wuue
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 table fixtures
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_szuum.ucx_t09pw', metastore_id=None, name='ucx_t09pw', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_szuum', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/Wuue', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1711527361636, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6iwm', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c6iwm', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1711527361636, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_svdcd', metastore_id=None, name='ucx_svdcd', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_szuum', metastore_id=None, name='ucx_szuum', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c6iwm', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6iwm.ucx_szuum', metastore_id=None, name='ucx_szuum', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw5] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
❌ test_table_migration_job_cluster_override: databricks.sdk.errors.platform.Unknown: (java.lang.SecurityException) PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration. (2m35.058s)
databricks.sdk.errors.platform.Unknown: (java.lang.SecurityException) PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s6wpx: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s6wpx
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s6wpx', metastore_id=None, name='ucx_s6wpx', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw5] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s6wpx: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s6wpx
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s6wpx', metastore_id=None, name='ucx_s6wpx', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s3hlc: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s3hlc
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s3hlc', metastore_id=None, name='ucx_s3hlc', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_s3hlc.ucx_tzrc9: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s3hlc/ucx_tzrc9
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_s3hlc.ucx_tzrc9', metastore_id=None, name='ucx_tzrc9', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_s3hlc', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_s3hlc/ucx_tzrc9', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/RnNo
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_s3hlc.ucx_tifzj: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s3hlc/ucx_tifzj
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_s3hlc.ucx_tifzj', metastore_id=None, name='ucx_tifzj', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_s3hlc', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/RnNo', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1711527437403, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cjdel', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cjdel', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1711527437403, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cjdel.ucx_s3hlc: https://DATABRICKS_HOST/explore/data/ucx_cjdel/ucx_s3hlc
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cjdel', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cjdel.ucx_s3hlc', metastore_id=None, name='ucx_s3hlc', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:17 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.ucx/config.yml) doesn't exist.
08:17 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
08:17 INFO [databricks.labs.ucx.installer.hms_lineage] HMS Lineage feature creates one system table named system.hms_to_uc_migration.table_access and helps in your migration process from HMS to UC by allowing you to programmatically query HMS lineage data.
08:17 INFO [databricks.labs.ucx.install] Fetching installations...
08:17 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
08:17 INFO [databricks.labs.ucx.install] Installing UCX v0.19.1+1920240327081720
08:17 INFO [databricks.labs.ucx.install] Creating dashboards...
08:17 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Estimates)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 01_0_group_migration.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 01_0_group_migration.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_metastore_assignment.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_metastore_assignment.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_data_modeling.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_data_modeling.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 03_0_data_migration.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 03_0_data_migration.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Main)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Azure)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Interactive)...
08:18 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_interactive.md because it's a text widget
08:18 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_interactive.md because it's a text widget
08:18 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_cluster_summary.md because it's a text widget
08:18 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_cluster_summary.md because it's a text widget
08:18 DEBUG [databricks.labs.ucx.installer.workflows] Creating jobs from tasks in main
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=099-destroy-schema
08:18 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:18 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
08:18 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.ucx/README for the next steps.
08:18 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-tables job: https://DATABRICKS_HOST#job/167379894117521
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s6wpx: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s6wpx
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s6wpx', metastore_id=None, name='ucx_s6wpx', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s3hlc: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s3hlc
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s3hlc', metastore_id=None, name='ucx_s3hlc', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_s3hlc.ucx_tzrc9: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s3hlc/ucx_tzrc9
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_s3hlc.ucx_tzrc9', metastore_id=None, name='ucx_tzrc9', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_s3hlc', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_s3hlc/ucx_tzrc9', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/RnNo
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_s3hlc.ucx_tifzj: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s3hlc/ucx_tifzj
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_s3hlc.ucx_tifzj', metastore_id=None, name='ucx_tifzj', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_s3hlc', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/RnNo', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1711527437403, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cjdel', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cjdel', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1711527437403, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
08:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cjdel.ucx_s3hlc: https://DATABRICKS_HOST/explore/data/ucx_cjdel/ucx_s3hlc
08:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cjdel', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cjdel.ucx_s3hlc', metastore_id=None, name='ucx_s3hlc', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:17 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.ucx/config.yml) doesn't exist.
08:17 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
08:17 INFO [databricks.labs.ucx.installer.hms_lineage] HMS Lineage feature creates one system table named system.hms_to_uc_migration.table_access and helps in your migration process from HMS to UC by allowing you to programmatically query HMS lineage data.
08:17 INFO [databricks.labs.ucx.install] Fetching installations...
08:17 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
08:17 INFO [databricks.labs.ucx.install] Installing UCX v0.19.1+1920240327081720
08:17 INFO [databricks.labs.ucx.install] Creating dashboards...
08:17 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Estimates)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 01_0_group_migration.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 01_0_group_migration.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_metastore_assignment.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_metastore_assignment.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_data_modeling.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_data_modeling.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 03_0_data_migration.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 03_0_data_migration.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Main)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Azure)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Interactive)...
08:18 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_interactive.md because it's a text widget
08:18 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_interactive.md because it's a text widget
08:18 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_cluster_summary.md because it's a text widget
08:18 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_cluster_summary.md because it's a text widget
08:18 DEBUG [databricks.labs.ucx.installer.workflows] Creating jobs from tasks in main
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=099-destroy-schema
08:18 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:18 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
08:18 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
08:18 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.ucx/README for the next steps.
08:18 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-tables job: https://DATABRICKS_HOST#job/167379894117521
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/RnNo
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 table fixtures
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_s3hlc.ucx_tzrc9', metastore_id=None, name='ucx_tzrc9', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_s3hlc', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_s3hlc/ucx_tzrc9', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_s3hlc.ucx_tifzj', metastore_id=None, name='ucx_tifzj', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_s3hlc', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/RnNo', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1711527437403, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cjdel', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cjdel', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1711527437403, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
08:19 INFO [databricks.labs.ucx.install] Deleting UCX v0.19.1+1920240327081942 from https://DATABRICKS_HOST
08:19 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_s6wpx
08:19 INFO [databricks.labs.ucx.install] Deleting jobs
08:19 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=638757748084781.
08:19 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=782157632674310.
08:19 INFO [databricks.labs.ucx.install] Deleting 099-destroy-schema job_id=720764196663049.
08:19 INFO [databricks.labs.ucx.install] Deleting assessment job_id=689786828298560.
08:19 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=474367012492680.
08:19 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=167379894117521.
08:19 INFO [databricks.labs.ucx.install] Deleting cluster policy
08:19 INFO [databricks.labs.ucx.install] Deleting secret scope
08:19 INFO [databricks.labs.ucx.install] UnInstalling UCX complete
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s6wpx', metastore_id=None, name='ucx_s6wpx', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_s3hlc', metastore_id=None, name='ucx_s3hlc', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cjdel', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cjdel.ucx_s3hlc', metastore_id=None, name='ucx_s3hlc', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw5] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
❌ test_running_real_assessment_job: databricks.labs.blueprint.parallel.ManyError: Detected 10 failures: Unknown: assess_CLOUD_ENV_service_principals: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-45d0c-63f76-ea657-6, kernel did not start within 80 seconds. (13m55.196s)
databricks.labs.blueprint.parallel.ManyError: Detected 10 failures: Unknown: assess_CLOUD_ENV_service_principals: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-45d0c-63f76-ea657-6, kernel did not start within 80 seconds.
----- stdout -----

------------------
----- stderr -----
0.00s - Debugger warning: It seems that frozen modules are being used, which may
0.00s - make the debugger miss breakpoints. Please pass -Xfrozen_modules=off
0.00s - to python to disable frozen modules.
0.00s - Note: Debugging will proceed. Set PYDEVD_DISABLE_FILE_VALIDATION=1 to disable this validation.

------------------, Unknown: assess_clusters: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-1c25c-adb65-0ec15-e, kernel did not start within 80 seconds.
----- stdout -----

------------------
----- stderr -----
0.00s - Debugger warning: It seems that frozen modules are being used, which may
0.00s - make the debugger miss breakpoints. Please pass -Xfrozen_modules=off
0.00s - to python to disable frozen modules.
0.00s - Note: Debugging will proceed. Set PYDEVD_DISABLE_FILE_VALIDATION=1 to disable this validation.

------------------, Unknown: assess_global_init_scripts: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-2697f-c8ee0-7771f-4, kernel did not start within 80 seconds.
----- stdout -----

------------------
----- stderr -----
0.00s - Debugger warning: It seems that frozen modules are being used, which may
0.00s - make the debugger miss breakpoints. Please pass -Xfrozen_modules=off
0.00s - to python to disable frozen modules.
0.00s - Note: Debugging will proceed. Set PYDEVD_DISABLE_FILE_VALIDATION=1 to disable this validation.

------------------, Unknown: assess_incompatible_submit_runs: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-680fd-43e2b-6213c-8, kernel did not start within 80 seconds.
----- stdout -----

------------------
----- stderr -----
0.08s - Debugger warning: It seems that frozen modules are being used, which may
0.00s - make the debugger miss breakpoints. Please pass -Xfrozen_modules=off
0.00s - to python to disable frozen modules.
0.00s - Note: Debugging will proceed. Set PYDEVD_DISABLE_FILE_VALIDATION=1 to disable this validation.

------------------, Unknown: assess_jobs: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-3e405-a1bf1-21b83-9, kernel did not start within 80 seconds.
----- stdout -----

------------------
----- stderr -----
0.01s - Debugger warning: It seems that frozen modules are being used, which may
0.00s - make the debugger miss breakpoints. Please pass -Xfrozen_modules=off
0.00s - to python to disable frozen modules.
0.00s - Note: Debugging will proceed. Set PYDEVD_DISABLE_FILE_VALIDATION=1 to disable this validation.

------------------, Unknown: assess_pipelines: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-6021d-718e6-cc2f1-b, kernel did not start within 80 seconds.
----- stdout -----

------------------
----- stderr -----
0.00s - Debugger warning: It seems that frozen modules are being used, which may
0.00s - make the debugger miss breakpoints. Please pass -Xfrozen_modules=off
0.00s - to python to disable frozen modules.
0.00s - Note: Debugging will proceed. Set PYDEVD_DISABLE_FILE_VALIDATION=1 to disable this validation.

------------------, Unknown: crawl_cluster_policies: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-691d3-ecef5-396df-7, kernel did not start within 80 seconds.
----- stdout -----

------------------
----- stderr -----
0.15s - Debugger warning: It seems that frozen modules are being used, which may
0.00s - make the debugger miss breakpoints. Please pass -Xfrozen_modules=off
0.00s - to python to disable frozen modules.
0.00s - Note: Debugging will proceed. Set PYDEVD_DISABLE_FILE_VALIDATION=1 to disable this validation.

------------------, Unknown: crawl_groups: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-3561b-bd0b4-a9225-2, kernel did not start within 80 seconds.
----- stdout -----

------------------
----- stderr -----
0.00s - Debugger warning: It seems that frozen modules are being used, which may
0.00s - make the debugger miss breakpoints. Please pass -Xfrozen_modules=off
0.00s - to python to disable frozen modules.
0.00s - Note: Debugging will proceed. Set PYDEVD_DISABLE_FILE_VALIDATION=1 to disable this validation.

------------------, Unknown: crawl_mounts: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-23f7d-f6c18-f1a19-d, kernel did not start within 80 seconds.
----- stdout -----

------------------
----- stderr -----
0.01s - Debugger warning: It seems that frozen modules are being used, which may
0.00s - make the debugger miss breakpoints. Please pass -Xfrozen_modules=off
0.00s - to python to disable frozen modules.
0.00s - Note: Debugging will proceed. Set PYDEVD_DISABLE_FILE_VALIDATION=1 to disable this validation.

------------------, Unknown: workspace_listing: PythonDriverLocal.PythonException: Unable to start python kernel for ReplId-4c4f2-3e77b-529be-3, kernel did not start within 80 seconds.
----- stdout -----

------------------
----- stderr -----
0.00s - Debugger warning: It seems that frozen modules are being used, which may
0.00s - make the debugger miss breakpoints. Please pass -Xfrozen_modules=off
0.00s - to python to disable frozen modules.
0.00s - Note: Debugging will proceed. Set PYDEVD_DISABLE_FILE_VALIDATION=1 to disable this validation.

------------------
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sdnna: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sdnna
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sdnna', metastore_id=None, name='ucx_sdnna', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw3] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sdnna: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sdnna
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sdnna', metastore_id=None, name='ucx_sdnna', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-31j5@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-31j5@example.com')], entitlements=[], external_id=None, groups=[], id='8935250399725064', name=Name(family_name=None, given_name='sdk-31j5@example.com'), roles=[], schemas=[<UserSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_CORE_2_0_USER: 'urn:ietf:params:scim:schemas:core:2.0:User'>, <UserSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_EXTENSION_WORKSPACE_2_0_USER: 'urn:ietf:params:scim:schemas:extension:workspace:2.0:User'>], user_name='sdk-31j5@example.com')
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Workspace group ucx_NJuC: https://DATABRICKS_HOST#setting/accounts/groups/129714538410601
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace group fixture: Group(display_name='ucx_NJuC', entitlements=[ComplexValue(display=None, primary=None, ref=None, type=None, value='allow-cluster-create')], external_id=None, groups=[], id='129714538410601', members=[ComplexValue(display='sdk-31j5@example.com', primary=None, ref='Users/8935250399725064', type=None, value='8935250399725064')], meta=ResourceMeta(resource_type='WorkspaceGroup'), roles=[], schemas=[<GroupSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_CORE_2_0_GROUP: 'urn:ietf:params:scim:schemas:core:2.0:Group'>])
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Account group ucx_NJuC: https://accounts.CLOUD_ENVdatabricks.net/users/groups/335392208723962/members
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added account group fixture: Group(display_name='ucx_NJuC', entitlements=[], external_id=None, groups=[], id='335392208723962', members=[ComplexValue(display='sdk-31j5@example.com', primary=None, ref='Users/8935250399725064', type=None, value='8935250399725064')], meta=None, roles=[], schemas=[<GroupSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_CORE_2_0_GROUP: 'urn:ietf:params:scim:schemas:core:2.0:Group'>])
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Cluster policy: https://DATABRICKS_HOST#setting/clusters/cluster-policies/view/001D0794456E23C3
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster policy fixture: CreatePolicyResponse(policy_id='001D0794456E23C3')
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster_policy permissions fixture: 001D0794456E23C3 [group_name admins CAN_USE] -> [group_name ucx_NJuC CAN_USE]
08:16 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.88gv/config.yml) doesn't exist.
08:16 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
08:16 INFO [databricks.labs.ucx.installer.hms_lineage] HMS Lineage feature creates one system table named system.hms_to_uc_migration.table_access and helps in your migration process from HMS to UC by allowing you to programmatically query HMS lineage data.
08:16 INFO [databricks.labs.ucx.install] Fetching installations...
08:16 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
08:16 INFO [databricks.labs.ucx.install] Installing UCX v0.19.1+1920240327081642
08:16 INFO [databricks.labs.ucx.install] Creating dashboards...
08:16 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
08:16 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [88GV] UCX  Assessment (Estimates)...
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 01_0_group_migration.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 01_0_group_migration.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_metastore_assignment.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_metastore_assignment.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_data_modeling.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_data_modeling.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 03_0_data_migration.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 03_0_data_migration.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
08:16 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [88GV] UCX  Assessment (Main)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [88GV] UCX  Assessment (Azure)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [88GV] UCX  Assessment (Interactive)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_interactive.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_interactive.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_cluster_summary.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_cluster_summary.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.installer.workflows] Creating jobs from tasks in main
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=099-destroy-schema
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
08:17 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:17 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
08:17 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.88gv/README for the next steps.
08:17 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/768836304858582
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sdnna: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sdnna
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sdnna', metastore_id=None, name='ucx_sdnna', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-31j5@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-31j5@example.com')], entitlements=[], external_id=None, groups=[], id='8935250399725064', name=Name(family_name=None, given_name='sdk-31j5@example.com'), roles=[], schemas=[<UserSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_CORE_2_0_USER: 'urn:ietf:params:scim:schemas:core:2.0:User'>, <UserSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_EXTENSION_WORKSPACE_2_0_USER: 'urn:ietf:params:scim:schemas:extension:workspace:2.0:User'>], user_name='sdk-31j5@example.com')
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Workspace group ucx_NJuC: https://DATABRICKS_HOST#setting/accounts/groups/129714538410601
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace group fixture: Group(display_name='ucx_NJuC', entitlements=[ComplexValue(display=None, primary=None, ref=None, type=None, value='allow-cluster-create')], external_id=None, groups=[], id='129714538410601', members=[ComplexValue(display='sdk-31j5@example.com', primary=None, ref='Users/8935250399725064', type=None, value='8935250399725064')], meta=ResourceMeta(resource_type='WorkspaceGroup'), roles=[], schemas=[<GroupSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_CORE_2_0_GROUP: 'urn:ietf:params:scim:schemas:core:2.0:Group'>])
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Account group ucx_NJuC: https://accounts.CLOUD_ENVdatabricks.net/users/groups/335392208723962/members
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added account group fixture: Group(display_name='ucx_NJuC', entitlements=[], external_id=None, groups=[], id='335392208723962', members=[ComplexValue(display='sdk-31j5@example.com', primary=None, ref='Users/8935250399725064', type=None, value='8935250399725064')], meta=None, roles=[], schemas=[<GroupSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_CORE_2_0_GROUP: 'urn:ietf:params:scim:schemas:core:2.0:Group'>])
08:16 INFO [databricks.labs.ucx.mixins.fixtures] Cluster policy: https://DATABRICKS_HOST#setting/clusters/cluster-policies/view/001D0794456E23C3
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster policy fixture: CreatePolicyResponse(policy_id='001D0794456E23C3')
08:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster_policy permissions fixture: 001D0794456E23C3 [group_name admins CAN_USE] -> [group_name ucx_NJuC CAN_USE]
08:16 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.88gv/config.yml) doesn't exist.
08:16 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
08:16 INFO [databricks.labs.ucx.installer.hms_lineage] HMS Lineage feature creates one system table named system.hms_to_uc_migration.table_access and helps in your migration process from HMS to UC by allowing you to programmatically query HMS lineage data.
08:16 INFO [databricks.labs.ucx.install] Fetching installations...
08:16 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
08:16 INFO [databricks.labs.ucx.install] Installing UCX v0.19.1+1920240327081642
08:16 INFO [databricks.labs.ucx.install] Creating dashboards...
08:16 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
08:16 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [88GV] UCX  Assessment (Estimates)...
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 01_0_group_migration.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 01_0_group_migration.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_metastore_assignment.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_metastore_assignment.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_data_modeling.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_data_modeling.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 03_0_data_migration.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 03_0_data_migration.md because it's a text widget
08:16 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
08:16 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [88GV] UCX  Assessment (Main)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [88GV] UCX  Assessment (Azure)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
08:17 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [88GV] UCX  Assessment (Interactive)...
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_interactive.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_interactive.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_cluster_summary.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_cluster_summary.md because it's a text widget
08:17 DEBUG [databricks.labs.ucx.installer.workflows] Creating jobs from tasks in main
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=099-destroy-schema
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
08:17 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:17 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
08:17 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
08:17 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.88gv/README for the next steps.
08:17 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/768836304858582
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 cluster_policy permissions fixtures
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] removing cluster_policy permissions fixture: 001D0794456E23C3 [group_name admins CAN_USE] -> [group_name ucx_NJuC CAN_USE]
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 cluster policy fixtures
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] removing cluster policy fixture: CreatePolicyResponse(policy_id='001D0794456E23C3')
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 workspace user fixtures
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] removing workspace user fixture: User(active=True, display_name='sdk-31j5@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-31j5@example.com')], entitlements=[], external_id=None, groups=[], id='8935250399725064', name=Name(family_name=None, given_name='sdk-31j5@example.com'), roles=[], schemas=[<UserSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_CORE_2_0_USER: 'urn:ietf:params:scim:schemas:core:2.0:User'>, <UserSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_EXTENSION_WORKSPACE_2_0_USER: 'urn:ietf:params:scim:schemas:extension:workspace:2.0:User'>], user_name='sdk-31j5@example.com')
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 account group fixtures
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] removing account group fixture: Group(display_name='ucx_NJuC', entitlements=[], external_id=None, groups=[], id='335392208723962', members=[ComplexValue(display='sdk-31j5@example.com', primary=None, ref='Users/8935250399725064', type=None, value='8935250399725064')], meta=None, roles=[], schemas=[<GroupSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_CORE_2_0_GROUP: 'urn:ietf:params:scim:schemas:core:2.0:Group'>])
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 workspace group fixtures
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] removing workspace group fixture: Group(display_name='ucx_NJuC', entitlements=[ComplexValue(display=None, primary=None, ref=None, type=None, value='allow-cluster-create')], external_id=None, groups=[], id='129714538410601', members=[ComplexValue(display='sdk-31j5@example.com', primary=None, ref='Users/8935250399725064', type=None, value='8935250399725064')], meta=ResourceMeta(resource_type='WorkspaceGroup'), roles=[], schemas=[<GroupSchema.URN_IETF_PARAMS_SCIM_SCHEMAS_CORE_2_0_GROUP: 'urn:ietf:params:scim:schemas:core:2.0:Group'>])
08:30 INFO [databricks.labs.ucx.install] Deleting UCX v0.19.1+1920240327083028 from https://DATABRICKS_HOST
08:30 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_sdnna
08:30 INFO [databricks.labs.ucx.install] Deleting jobs
08:30 INFO [databricks.labs.ucx.install] Deleting 099-destroy-schema job_id=377684223469218.
08:30 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=1109644396192812.
08:30 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=616005084413804.
08:30 INFO [databricks.labs.ucx.install] Deleting assessment job_id=768836304858582.
08:30 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=803480144924924.
08:30 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=1021866725530568.
08:30 INFO [databricks.labs.ucx.install] Deleting cluster policy
08:30 INFO [databricks.labs.ucx.install] Deleting secret scope
08:30 INFO [databricks.labs.ucx.install] UnInstalling UCX complete
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 schema fixtures
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sdnna', metastore_id=None, name='ucx_sdnna', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw3] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
❌ test_partitioned_tables: databricks.labs.blueprint.parallel.ManyError: Detected 10 failures: Unknown: assess_CLOUD_ENV_service_principals: run failed with error message (10m52.62s)
databricks.labs.blueprint.parallel.ManyError: Detected 10 failures: Unknown: assess_CLOUD_ENV_service_principals: run failed with error message
 Could not reach driver of cluster DATABRICKS_CLUSTER_ID., Unknown: assess_clusters: run failed with error message
 Could not reach driver of cluster DATABRICKS_CLUSTER_ID., Unknown: assess_global_init_scripts: run failed with error message
 Could not reach driver of cluster DATABRICKS_CLUSTER_ID., Unknown: assess_incompatible_submit_runs: run failed with error message
 Could not reach driver of cluster DATABRICKS_CLUSTER_ID., Unknown: assess_jobs: run failed with error message
 Could not reach driver of cluster DATABRICKS_CLUSTER_ID., Unknown: assess_pipelines: run failed with error message
 Could not reach driver of cluster DATABRICKS_CLUSTER_ID., Unknown: crawl_cluster_policies: run failed with error message
 Could not reach driver of cluster DATABRICKS_CLUSTER_ID., Unknown: crawl_groups: run failed with error message
 Could not reach driver of cluster DATABRICKS_CLUSTER_ID., Unknown: crawl_mounts: run failed with error message
 Could not reach driver of cluster DATABRICKS_CLUSTER_ID., Unknown: workspace_listing: run failed with error message
 Could not reach driver of cluster DATABRICKS_CLUSTER_ID.
08:19 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sjidu: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sjidu
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sjidu', metastore_id=None, name='ucx_sjidu', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw5] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
08:19 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sjidu: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sjidu
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sjidu', metastore_id=None, name='ucx_sjidu', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:20 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.3amI/config.yml) doesn't exist.
08:20 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
08:20 INFO [databricks.labs.ucx.installer.hms_lineage] HMS Lineage feature creates one system table named system.hms_to_uc_migration.table_access and helps in your migration process from HMS to UC by allowing you to programmatically query HMS lineage data.
08:20 INFO [databricks.labs.ucx.install] Fetching installations...
08:20 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
08:20 INFO [databricks.labs.ucx.install] Installing UCX v0.19.1+1920240327082003
08:20 INFO [databricks.labs.ucx.install] Creating dashboards...
08:20 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
08:20 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [3AMI] UCX  Assessment (Estimates)...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 01_0_group_migration.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 01_0_group_migration.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_metastore_assignment.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_metastore_assignment.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_data_modeling.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_data_modeling.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 03_0_data_migration.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 03_0_data_migration.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
08:20 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [3AMI] UCX  Assessment (Main)...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
08:20 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [3AMI] UCX  Assessment (Azure)...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
08:20 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [3AMI] UCX  Assessment (Interactive)...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_interactive.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_interactive.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_cluster_summary.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_cluster_summary.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.installer.workflows] Creating jobs from tasks in main
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=099-destroy-schema
08:20 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:20 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
08:20 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.3amI/README for the next steps.
08:20 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_svimz: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svimz
08:20 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_svimz', metastore_id=None, name='ucx_svimz', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:20 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/520403896379082
08:19 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sjidu: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sjidu
08:19 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sjidu', metastore_id=None, name='ucx_sjidu', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:20 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.3amI/config.yml) doesn't exist.
08:20 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
08:20 INFO [databricks.labs.ucx.installer.hms_lineage] HMS Lineage feature creates one system table named system.hms_to_uc_migration.table_access and helps in your migration process from HMS to UC by allowing you to programmatically query HMS lineage data.
08:20 INFO [databricks.labs.ucx.install] Fetching installations...
08:20 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
08:20 INFO [databricks.labs.ucx.install] Installing UCX v0.19.1+1920240327082003
08:20 INFO [databricks.labs.ucx.install] Creating dashboards...
08:20 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
08:20 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [3AMI] UCX  Assessment (Estimates)...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 01_0_group_migration.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 01_0_group_migration.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_metastore_assignment.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_metastore_assignment.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_data_modeling.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_data_modeling.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 03_0_data_migration.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 03_0_data_migration.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
08:20 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [3AMI] UCX  Assessment (Main)...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
08:20 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [3AMI] UCX  Assessment (Azure)...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/interactive...
08:20 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [3AMI] UCX  Assessment (Interactive)...
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_interactive.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_interactive.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_cluster_summary.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_cluster_summary.md because it's a text widget
08:20 DEBUG [databricks.labs.ucx.installer.workflows] Creating jobs from tasks in main
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=099-destroy-schema
08:20 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:20 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
08:20 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
08:20 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.3amI/README for the next steps.
08:20 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_svimz: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svimz
08:20 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_svimz', metastore_id=None, name='ucx_svimz', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:20 DEBUG [databricks.labs.ucx.installer.workflows] starting assessment job: https://DATABRICKS_HOST#job/520403896379082
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures
08:30 INFO [databricks.labs.ucx.install] Deleting UCX v0.19.1+1920240327083034 from https://DATABRICKS_HOST
08:30 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_sjidu
08:30 INFO [databricks.labs.ucx.install] Deleting jobs
08:30 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=247631758630134.
08:30 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=878422781657667.
08:30 INFO [databricks.labs.ucx.install] Deleting 099-destroy-schema job_id=642639324971359.
08:30 INFO [databricks.labs.ucx.install] Deleting assessment job_id=520403896379082.
08:30 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=1074522641301285.
08:30 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=510710000608580.
08:30 INFO [databricks.labs.ucx.install] Deleting cluster policy
08:30 INFO [databricks.labs.ucx.install] Deleting secret scope
08:30 INFO [databricks.labs.ucx.install] UnInstalling UCX complete
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 schema fixtures
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sjidu', metastore_id=None, name='ucx_sjidu', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
08:30 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_svimz', metastore_id=None, name='ucx_svimz', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw5] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python

Flaky tests:

  • 🤪 test_replace_workspace_groups_with_account_groups (1m31.31s)
  • 🤪 test_job_failure_propagates_correct_error_message_and_logs (12m25.181s)
  • 🤪 test_repair_run_workflow_job (10m52.844s)

Running from acceptance #1794

@nfx nfx merged commit 86adf16 into main Mar 27, 2024
7 of 8 checks passed
@nfx nfx deleted the feature/job_assessment_flagging_jar branch March 27, 2024 13:35
nfx added a commit that referenced this pull request Mar 28, 2024
* Added ACL migration to `migrate-tables` workflow ([#1135](#1135)).
* Added AVRO to supported format to be upgraded by SYNC ([#1134](#1134)). In this release, the `hive_metastore` package's `tables.py` file has been updated to add AVRO as a supported format for the SYNC upgrade functionality. This change includes AVRO in the list of supported table formats in the `is_format_supported_for_sync` method, which checks if the table format is not `None` and if the format's uppercase value is one of the supported formats. The addition of AVRO enables it to be upgraded using the SYNC functionality. Moreover, a new format called BINARYFILE has been introduced, which is not supported for SYNC upgrade. This release is part of the implementation of issue [#1134](#1134), improving the compatibility of the SYNC upgrade functionality with various data formats.
* Added `is_partitioned` column ([#1130](#1130)). A new column, `is_partitioned`, has been added to the `ucx.tables` table in the assessment module, indicating whether the table is partitioned or not with values `Yes` or "No". This change addresses issue [#871](#871) and has been manually tested. The commit also includes updated documentation for the modified table. No new methods, CLI commands, workflows, or tests (unit, integration) have been introduced as part of this change.
* Added assessment of interactive cluster usage compared to UC compute limitations ([#1123](#1123)).
* Added external location validation when creating catalogs with `create-catalogs-schemas` command ([#1110](#1110)).
* Added flag to Job to identify Job submitted by jar ([#1088](#1088)). The open-source library has been updated with several new features aimed at enhancing user functionality and convenience. These updates include the addition of a new sorting algorithm, which provides users with an efficient and customizable method for organizing data. Additionally, a new caching mechanism has been implemented, improving the library's performance and reducing the amount of time required to access frequently used data. Furthermore, the library now supports multi-threading, enabling users to perform multiple operations simultaneously and increase overall productivity. Lastly, a new error handling system has been developed, providing users with more informative and actionable feedback when unexpected issues arise. These changes are a significant step forward in improving the library's performance, functionality, and usability for all users.
* Bump databricks-sdk from 0.22.0 to 0.23.0 ([#1121](#1121)). In this version update, `databricks-sdk` is upgraded from 0.22.0 to 0.23.0, introducing significant changes to the handling of AWS and Azure identities. The `AwsIamRole` class is replaced with `AwsIamRoleRequest` in the `databricks.sdk.service.catalog` module, affecting the creation of AWS storage credentials using IAM roles. The `create` function in `src/databricks/labs/ucx/aws/credentials.py` is updated to accommodate this modification. Additionally, the `AwsIamRole` argument in the `create` function of `fixtures.py` in the `databricks/labs/ucx/mixins` directory is replaced with `AwsIamRoleRequest`. The tests in `tests/integration/aws/test_access.py` are also updated to utilize `AwsIamRoleRequest`, and `StorageCredentialInfo` in `tests/unit/azure/test_credentials.py` now uses `AwsIamRoleResponse` instead of `AwsIamRole`. The new classes, `AwsIamRoleRequest` and `AwsIamRoleResponse`, likely include new features or bug fixes for AWS IAM roles. These changes require software engineers to thoroughly assess their codebase and adjust any relevant functions accordingly.
* Deploy static views needed by [#1123](#1123) interactive dashboard ([#1139](#1139)). In this update, we have added two new views, `misc_patterns_vw` and `code_patterns_vw`, to the `install.py` script in the `databricks/labs/ucx` directory. These views were originally intended to be deployed with a previous update ([#1123](#1123)) but were inadvertently overlooked. The addition of these views addresses issues with queries in the `interactive` dashboard. The `deploy_schema` function has been updated with two new lines, `deployer.deploy_view("misc_patterns", "queries/views/misc_patterns.sql")` and `deployer.deploy_view("code_patterns", "queries/views/code_patterns.sql")`, to deploy the new views using their respective SQL files from the `queries/views` directory. No other modifications have been made to the file.
* Fixed Table ACL migration logic ([#1149](#1149)). The open-source library has been updated with several new features, providing enhanced functionality for software engineers. A new utility class has been added to simplify the process of working with collections, offering methods to filter, map, and reduce elements in a performant manner. Additionally, a new configuration system has been implemented, allowing users to easily customize library behavior through a simple JSON format. Finally, we have added support for asynchronous processing, enabling efficient handling of I/O-bound tasks and improving overall application performance. These features have been thoroughly tested and are ready for use in your projects.
* Fixed `AssertionError: assert '14.3.x-scala2.12' == '15.0.x-scala2.12'` from nightly integration tests ([#1120](#1120)). In this release, the open-source library has been updated with several new features to enhance functionality and provide more options to users. The library now supports multi-threading, allowing for more efficient processing of large datasets. Additionally, a new algorithm for data compression has been implemented, resulting in reduced memory usage and faster data transfer. The library API has also been expanded, with new methods for sorting and filtering data, as well as improved error handling. These changes aim to provide a more robust and performant library, making it an even more valuable tool for software engineers.
* Increase code coverage by 1 percent ([#1125](#1125)).
* Skip installation if remote and local version is the same, provide prompt to override ([#1084](#1084)). In this release, the `new_installation` workflow in the open-source library has been enhanced to include a new use case for handling identical remote and local versions of UCX. When the remote and local versions are the same, the user is now prompted and if no override is requested, a RuntimeWarning is raised. Additionally, users are now prompted to update the existing installation and if confirmed, the installation proceeds. These modifications include manual testing and new unit tests to ensure functionality. These changes provide users with more control over their installation process and address a specific use case for handling identical UCX versions.
* Updated databricks-labs-lsql requirement from ~=0.2.2 to >=0.2.2,<0.4.0 ([#1137](#1137)). The open-source library has been updated with several new features to enhance usability and functionality. Firstly, we have added support for asynchronous processing, allowing for more efficient handling of large data sets and improving overall performance. Additionally, a new configuration system has been implemented, which simplifies the setup process for users and increases customization options. We have also included a new error handling mechanism that provides more detailed and actionable information, making it easier to diagnose and resolve issues. Lastly, we have made significant improvements to the library's documentation, including updated examples, guides, and an expanded API reference. These changes are part of our ongoing commitment to improving the library and providing the best possible user experience.
* [Experimental] Add support for permission migration API ([#1080](#1080)).

Dependency updates:

 * Updated databricks-labs-lsql requirement from ~=0.2.2 to >=0.2.2,<0.4.0 ([#1137](#1137)).
@nfx nfx mentioned this pull request Mar 28, 2024
nfx added a commit that referenced this pull request Mar 28, 2024
* Added ACL migration to `migrate-tables` workflow
([#1135](#1135)).
* Added AVRO to supported format to be upgraded by SYNC
([#1134](#1134)). In this
release, the `hive_metastore` package's `tables.py` file has been
updated to add AVRO as a supported format for the SYNC upgrade
functionality. This change includes AVRO in the list of supported table
formats in the `is_format_supported_for_sync` method, which checks if
the table format is not `None` and if the format's uppercase value is
one of the supported formats. The addition of AVRO enables it to be
upgraded using the SYNC functionality. Moreover, a new format called
BINARYFILE has been introduced, which is not supported for SYNC upgrade.
This release is part of the implementation of issue
[#1134](#1134), improving
the compatibility of the SYNC upgrade functionality with various data
formats.
* Added `is_partitioned` column
([#1130](#1130)). A new
column, `is_partitioned`, has been added to the `ucx.tables` table in
the assessment module, indicating whether the table is partitioned or
not with values `Yes` or "No". This change addresses issue
[#871](#871) and has been
manually tested. The commit also includes updated documentation for the
modified table. No new methods, CLI commands, workflows, or tests (unit,
integration) have been introduced as part of this change.
* Added assessment of interactive cluster usage compared to UC compute
limitations
([#1123](#1123)).
* Added external location validation when creating catalogs with
`create-catalogs-schemas` command
([#1110](#1110)).
* Added flag to Job to identify Job submitted by jar
([#1088](#1088)). The
open-source library has been updated with several new features aimed at
enhancing user functionality and convenience. These updates include the
addition of a new sorting algorithm, which provides users with an
efficient and customizable method for organizing data. Additionally, a
new caching mechanism has been implemented, improving the library's
performance and reducing the amount of time required to access
frequently used data. Furthermore, the library now supports
multi-threading, enabling users to perform multiple operations
simultaneously and increase overall productivity. Lastly, a new error
handling system has been developed, providing users with more
informative and actionable feedback when unexpected issues arise. These
changes are a significant step forward in improving the library's
performance, functionality, and usability for all users.
* Bump databricks-sdk from 0.22.0 to 0.23.0
([#1121](#1121)). In this
version update, `databricks-sdk` is upgraded from 0.22.0 to 0.23.0,
introducing significant changes to the handling of AWS and Azure
identities. The `AwsIamRole` class is replaced with `AwsIamRoleRequest`
in the `databricks.sdk.service.catalog` module, affecting the creation
of AWS storage credentials using IAM roles. The `create` function in
`src/databricks/labs/ucx/aws/credentials.py` is updated to accommodate
this modification. Additionally, the `AwsIamRole` argument in the
`create` function of `fixtures.py` in the `databricks/labs/ucx/mixins`
directory is replaced with `AwsIamRoleRequest`. The tests in
`tests/integration/aws/test_access.py` are also updated to utilize
`AwsIamRoleRequest`, and `StorageCredentialInfo` in
`tests/unit/azure/test_credentials.py` now uses `AwsIamRoleResponse`
instead of `AwsIamRole`. The new classes, `AwsIamRoleRequest` and
`AwsIamRoleResponse`, likely include new features or bug fixes for AWS
IAM roles. These changes require software engineers to thoroughly assess
their codebase and adjust any relevant functions accordingly.
* Deploy static views needed by
[#1123](#1123) interactive
dashboard ([#1139](#1139)).
In this update, we have added two new views, `misc_patterns_vw` and
`code_patterns_vw`, to the `install.py` script in the
`databricks/labs/ucx` directory. These views were originally intended to
be deployed with a previous update
([#1123](#1123)) but were
inadvertently overlooked. The addition of these views addresses issues
with queries in the `interactive` dashboard. The `deploy_schema`
function has been updated with two new lines,
`deployer.deploy_view("misc_patterns",
"queries/views/misc_patterns.sql")` and
`deployer.deploy_view("code_patterns",
"queries/views/code_patterns.sql")`, to deploy the new views using their
respective SQL files from the `queries/views` directory. No other
modifications have been made to the file.
* Fixed Table ACL migration logic
([#1149](#1149)). The
open-source library has been updated with several new features,
providing enhanced functionality for software engineers. A new utility
class has been added to simplify the process of working with
collections, offering methods to filter, map, and reduce elements in a
performant manner. Additionally, a new configuration system has been
implemented, allowing users to easily customize library behavior through
a simple JSON format. Finally, we have added support for asynchronous
processing, enabling efficient handling of I/O-bound tasks and improving
overall application performance. These features have been thoroughly
tested and are ready for use in your projects.
* Fixed `AssertionError: assert '14.3.x-scala2.12' ==
'15.0.x-scala2.12'` from nightly integration tests
([#1120](#1120)). In this
release, the open-source library has been updated with several new
features to enhance functionality and provide more options to users. The
library now supports multi-threading, allowing for more efficient
processing of large datasets. Additionally, a new algorithm for data
compression has been implemented, resulting in reduced memory usage and
faster data transfer. The library API has also been expanded, with new
methods for sorting and filtering data, as well as improved error
handling. These changes aim to provide a more robust and performant
library, making it an even more valuable tool for software engineers.
* Increase code coverage by 1 percent
([#1125](#1125)).
* Skip installation if remote and local version is the same, provide
prompt to override
([#1084](#1084)). In this
release, the `new_installation` workflow in the open-source library has
been enhanced to include a new use case for handling identical remote
and local versions of UCX. When the remote and local versions are the
same, the user is now prompted and if no override is requested, a
RuntimeWarning is raised. Additionally, users are now prompted to update
the existing installation and if confirmed, the installation proceeds.
These modifications include manual testing and new unit tests to ensure
functionality. These changes provide users with more control over their
installation process and address a specific use case for handling
identical UCX versions.
* Updated databricks-labs-lsql requirement from ~=0.2.2 to
>=0.2.2,<0.4.0
([#1137](#1137)). The
open-source library has been updated with several new features to
enhance usability and functionality. Firstly, we have added support for
asynchronous processing, allowing for more efficient handling of large
data sets and improving overall performance. Additionally, a new
configuration system has been implemented, which simplifies the setup
process for users and increases customization options. We have also
included a new error handling mechanism that provides more detailed and
actionable information, making it easier to diagnose and resolve issues.
Lastly, we have made significant improvements to the library's
documentation, including updated examples, guides, and an expanded API
reference. These changes are part of our ongoing commitment to improving
the library and providing the best possible user experience.
* [Experimental] Add support for permission migration API
([#1080](#1080)).

Dependency updates:

* Updated databricks-labs-lsql requirement from ~=0.2.2 to
>=0.2.2,<0.4.0
([#1137](#1137)).
@zcking
Copy link

zcking commented Jun 14, 2024

I have lots of JAR task jobs that 100% DO use unity catalog already, but because of this change, the UCX assessment is now reporting them as failures.

Am I misunderstanding how this change is a "feature"? @nfx

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
step/assessment go/uc/upgrade - Assessment Step
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Unable to flag jobs submitted as JARs
3 participants