databrickslabs / ucx

Automated migrations to Unity Catalog
Other
221 stars 77 forks source link

whitelist salesforce-uni2ts #2058

Closed ericvergnaud closed 2 months ago

ericvergnaud commented 3 months ago

Changes

whitelist salesforce-uni2ts

Linked issues

Progresses #1901

Functionality

None

Tests

github-actions[bot] commented 3 months ago

❌ 75/79 passed, 4 failed, 18 skipped, 5h45m11s total

❌ test_group: TimeoutError: Timed out after 0:00:30 (34.268s) ``` TimeoutError: Timed out after 0:00:30 [gw3] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-jd0dudku@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-jd0dudku@example.com')], entitlements=[], external_id=None, groups=[], id='8683517988039718', name=Name(family_name=None, given_name='sdk-jd0dudku@example.com'), roles=[], schemas=[, ], user_name='sdk-jd0dudku@example.com') 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-jd0dudku@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-jd0dudku@example.com')], entitlements=[], external_id=None, groups=[], id='8683517988039718', name=Name(family_name=None, given_name='sdk-jd0dudku@example.com'), roles=[], schemas=[, ], user_name='sdk-jd0dudku@example.com') 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 workspace user fixtures 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] removing workspace user fixture: User(active=True, display_name='sdk-jd0dudku@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-jd0dudku@example.com')], entitlements=[], external_id=None, groups=[], id='8683517988039718', name=Name(family_name=None, given_name='sdk-jd0dudku@example.com'), roles=[], schemas=[, ], user_name='sdk-jd0dudku@example.com') 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures [gw3] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```
❌ test_table_migration_job_refreshes_migration_status[hiveserde-migrate-external-tables-ctas]: TimeoutError: Timed out after 0:05:00 (18m14.501s) ``` TimeoutError: Timed out after 0:05:00 11:30 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/sHKk 11:31 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek 11:31 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.hiveserde_in_place_pbrek', metastore_id=None, name='hiveserde_in_place_pbrek', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:31 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek 11:31 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_pbrek.parquet_serde_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek/parquet_serde_pbrek 11:31 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.parquet_serde_pbrek', metastore_id=None, name='parquet_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/parquet_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:32 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_pbrek.orc_serde_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek/orc_serde_pbrek 11:32 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.orc_serde_pbrek', metastore_id=None, name='orc_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/orc_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:32 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_pbrek.avro_serde_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek/avro_serde_pbrek 11:32 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.avro_serde_pbrek', metastore_id=None, name='avro_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/avro_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:33 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720006378870, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c2lei', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c2lei', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1720006378870, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:33 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_c2lei.hiveserde_in_place_pbrek: https://DATABRICKS_HOST/explore/data/ucx_c2lei/hiveserde_in_place_pbrek 11:33 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c2lei', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c2lei.hiveserde_in_place_pbrek', metastore_id=None, name='hiveserde_in_place_pbrek', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:33 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_scyew: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_scyew 11:33 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_scyew', metastore_id=None, name='ucx_scyew', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw2] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 11:30 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/sHKk 11:31 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek 11:31 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.hiveserde_in_place_pbrek', metastore_id=None, name='hiveserde_in_place_pbrek', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:31 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek 11:31 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_pbrek.parquet_serde_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek/parquet_serde_pbrek 11:31 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.parquet_serde_pbrek', metastore_id=None, name='parquet_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/parquet_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:32 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_pbrek.orc_serde_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek/orc_serde_pbrek 11:32 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.orc_serde_pbrek', metastore_id=None, name='orc_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/orc_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:32 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_pbrek.avro_serde_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek/avro_serde_pbrek 11:32 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.avro_serde_pbrek', metastore_id=None, name='avro_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/avro_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:33 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720006378870, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c2lei', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c2lei', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1720006378870, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:33 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_c2lei.hiveserde_in_place_pbrek: https://DATABRICKS_HOST/explore/data/ucx_c2lei/hiveserde_in_place_pbrek 11:33 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c2lei', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c2lei.hiveserde_in_place_pbrek', metastore_id=None, name='hiveserde_in_place_pbrek', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:33 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_scyew: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_scyew 11:33 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_scyew', metastore_id=None, name='ucx_scyew', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:36 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.hJni/config.yml) doesn't exist. 11:36 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 11:37 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. 11:37 INFO [databricks.labs.ucx.install] Fetching installations... 11:37 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.hJni is corrupted. Skipping... 11:38 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 11:38 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:38 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:39 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+7020240703113901 11:39 INFO [databricks.labs.ucx.install] Creating ucx schemas... 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 11:42 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.hJni/README for the next steps. 11:42 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-tables-ctas job: https://DATABRICKS_HOST#job/645839240509114 11:30 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/sHKk 11:31 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek 11:31 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.hiveserde_in_place_pbrek', metastore_id=None, name='hiveserde_in_place_pbrek', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:31 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek 11:31 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_pbrek.parquet_serde_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek/parquet_serde_pbrek 11:31 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.parquet_serde_pbrek', metastore_id=None, name='parquet_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/parquet_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:32 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_pbrek.orc_serde_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek/orc_serde_pbrek 11:32 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.orc_serde_pbrek', metastore_id=None, name='orc_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/orc_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:32 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_pbrek.avro_serde_pbrek: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_pbrek/avro_serde_pbrek 11:32 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.avro_serde_pbrek', metastore_id=None, name='avro_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/avro_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:33 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720006378870, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c2lei', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c2lei', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1720006378870, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:33 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_c2lei.hiveserde_in_place_pbrek: https://DATABRICKS_HOST/explore/data/ucx_c2lei/hiveserde_in_place_pbrek 11:33 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c2lei', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c2lei.hiveserde_in_place_pbrek', metastore_id=None, name='hiveserde_in_place_pbrek', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:33 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_scyew: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_scyew 11:33 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_scyew', metastore_id=None, name='ucx_scyew', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:36 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.hJni/config.yml) doesn't exist. 11:36 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 11:37 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. 11:37 INFO [databricks.labs.ucx.install] Fetching installations... 11:37 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.hJni is corrupted. Skipping... 11:38 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 11:38 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:38 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:39 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+7020240703113901 11:39 INFO [databricks.labs.ucx.install] Creating ucx schemas... 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 11:42 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 11:42 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.hJni/README for the next steps. 11:42 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-tables-ctas job: https://DATABRICKS_HOST#job/645839240509114 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_storage_dir fixtures 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/sHKk 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 cluster fixtures 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures 11:46 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720006378870, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c2lei', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c2lei', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1720006378870, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:46 INFO [databricks.labs.ucx.install] Deleting UCX v0.27.2+7020240703113901 from https://DATABRICKS_HOST 11:46 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_scyew 11:47 INFO [databricks.labs.ucx.install] Deleting jobs 11:47 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=752489137498202. 11:47 INFO [databricks.labs.ucx.install] Deleting migrate-external-hiveserde-tables-in-place-experimental job_id=163070967187963. 11:47 INFO [databricks.labs.ucx.install] Deleting migrate-external-tables-ctas job_id=645839240509114. 11:47 INFO [databricks.labs.ucx.install] Deleting migrate-tables-in-mounts-experimental job_id=970656044859825. 11:47 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=1035522606387637. 11:47 INFO [databricks.labs.ucx.install] Deleting assessment job_id=461943883407612. 11:47 INFO [databricks.labs.ucx.install] Deleting migrate-data-reconciliation job_id=1096400704393811. 11:47 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=600447807752706. 11:47 INFO [databricks.labs.ucx.install] Deleting migrate-groups-experimental job_id=360888799392298. 11:47 INFO [databricks.labs.ucx.install] Deleting experimental-workflow-linter job_id=706187936302690. 11:47 INFO [databricks.labs.ucx.install] Deleting scan-tables-in-mounts-experimental job_id=491621970250305. 11:47 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=975692803056460. 11:47 INFO [databricks.labs.ucx.install] Deleting failing job_id=735145442407770. 11:47 INFO [databricks.labs.ucx.install] Deleting cluster policy 11:47 INFO [databricks.labs.ucx.install] Deleting secret scope 11:47 INFO [databricks.labs.ucx.install] UnInstalling UCX complete 11:47 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace user fixtures 11:47 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 account group fixtures 11:47 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 11:47 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 11:47 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 table fixtures 11:47 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.parquet_serde_pbrek', metastore_id=None, name='parquet_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/parquet_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.orc_serde_pbrek', metastore_id=None, name='orc_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/orc_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:47 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=None, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.hiveserde_in_place_pbrek.avro_serde_pbrek', metastore_id=None, name='avro_serde_pbrek', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_pbrek', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_pbrek/avro_serde_pbrek', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:48 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures 11:48 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.hiveserde_in_place_pbrek', metastore_id=None, name='hiveserde_in_place_pbrek', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:48 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c2lei', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c2lei.hiveserde_in_place_pbrek', metastore_id=None, name='hiveserde_in_place_pbrek', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:48 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_scyew', metastore_id=None, name='ucx_scyew', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw2] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```
❌ test_running_real_workflow_linter_job: TimeoutError: Timed out after 0:02:00 (8m9.678s) ``` TimeoutError: Timed out after 0:02:00 [gw1] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 11:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added directory fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-LVjp 11:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added notebook fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-LVjp/notebook.ipynb 11:49 INFO [databricks.labs.ucx.mixins.fixtures] Job: https://DATABRICKS_HOST#job/306397343485356 11:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added job fixture: CreateResponse(job_id=306397343485356) 11:50 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sabsp: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sabsp 11:50 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_sabsp', metastore_id=None, name='ucx_sabsp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:50 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.FsFt/config.yml) doesn't exist. 11:50 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 11:50 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. 11:50 INFO [databricks.labs.ucx.install] Fetching installations... 11:50 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 11:50 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:50 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:50 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+7020240703115035 11:50 INFO [databricks.labs.ucx.install] Creating ucx schemas... 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 11:53 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.FsFt/README for the next steps. 11:53 DEBUG [databricks.labs.ucx.installer.workflows] starting experimental-workflow-linter job: https://DATABRICKS_HOST#job/908853148061853 11:56 DEBUG [databricks.labs.ucx.installer.workflows] Validating experimental-workflow-linter workflow: https://DATABRICKS_HOST#job/908853148061853 11:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added directory fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-LVjp 11:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added notebook fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-LVjp/notebook.ipynb 11:49 INFO [databricks.labs.ucx.mixins.fixtures] Job: https://DATABRICKS_HOST#job/306397343485356 11:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added job fixture: CreateResponse(job_id=306397343485356) 11:50 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sabsp: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sabsp 11:50 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_sabsp', metastore_id=None, name='ucx_sabsp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:50 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.FsFt/config.yml) doesn't exist. 11:50 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 11:50 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. 11:50 INFO [databricks.labs.ucx.install] Fetching installations... 11:50 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 11:50 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:50 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:50 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+7020240703115035 11:50 INFO [databricks.labs.ucx.install] Creating ucx schemas... 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 11:52 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 11:53 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 11:53 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.FsFt/README for the next steps. 11:53 DEBUG [databricks.labs.ucx.installer.workflows] starting experimental-workflow-linter job: https://DATABRICKS_HOST#job/908853148061853 11:56 DEBUG [databricks.labs.ucx.installer.workflows] Validating experimental-workflow-linter workflow: https://DATABRICKS_HOST#job/908853148061853 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 job fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing job fixture: CreateResponse(job_id=306397343485356) 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 directory fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing directory fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-LVjp 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 notebook fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing notebook fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-LVjp/notebook.ipynb 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while notebook /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-LVjp/notebook.ipynb teardown: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-LVjp/notebook.ipynb) doesn't exist. 11:57 INFO [databricks.labs.ucx.install] Deleting UCX v0.27.2+7020240703115035 from https://DATABRICKS_HOST 11:57 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_sabsp 11:57 INFO [databricks.labs.ucx.install] Deleting jobs 11:57 INFO [databricks.labs.ucx.install] Deleting migrate-groups-experimental job_id=182165715181997. 11:57 INFO [databricks.labs.ucx.install] Deleting scan-tables-in-mounts-experimental job_id=149135354732667. 11:57 INFO [databricks.labs.ucx.install] Deleting migrate-data-reconciliation job_id=400889337198666. 11:57 INFO [databricks.labs.ucx.install] Deleting migrate-external-hiveserde-tables-in-place-experimental job_id=667202134780203. 11:57 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=304337597175708. 11:57 INFO [databricks.labs.ucx.install] Deleting experimental-workflow-linter job_id=908853148061853. 11:57 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=708881042757624. 11:57 INFO [databricks.labs.ucx.install] Deleting migrate-tables-in-mounts-experimental job_id=874410797320678. 11:57 INFO [databricks.labs.ucx.install] Deleting failing job_id=225027240748677. 11:57 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=606457457797354. 11:57 INFO [databricks.labs.ucx.install] Deleting assessment job_id=1062817149025113. 11:57 INFO [databricks.labs.ucx.install] Deleting migrate-external-tables-ctas job_id=713680812437406. 11:57 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=661796504249984. 11:57 INFO [databricks.labs.ucx.install] Deleting cluster policy 11:57 INFO [databricks.labs.ucx.install] Deleting secret scope 11:57 INFO [databricks.labs.ucx.install] UnInstalling UCX complete 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace user fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 account group fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 schema fixtures 11:57 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_sabsp', metastore_id=None, name='ucx_sabsp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw1] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```
❌ test_create_catalog_schema_with_principal_acl_CLOUD_ENV: AssertionError: assert PrivilegeAssignment(principal='sdk-zlguejdf@example.com', privileges=[]) in [PrivilegeAssignment(principal='sdk-irv696wx@example.com', privileges=[]), Privile...>]), PrivilegeAssignment(principal='sdk-xegrhhsh@example.com', privileges=[]), ...] (36m21.956s) ``` AssertionError: assert PrivilegeAssignment(principal='sdk-zlguejdf@example.com', privileges=[]) in [PrivilegeAssignment(principal='sdk-irv696wx@example.com', privileges=[]), Privile...>]), PrivilegeAssignment(principal='sdk-xegrhhsh@example.com', privileges=[]), ...] + where [PrivilegeAssignment(principal='sdk-irv696wx@example.com', privileges=[]), Privile...>]), PrivilegeAssignment(principal='sdk-xegrhhsh@example.com', privileges=[]), ...] = PermissionsList(privilege_assignments=[PrivilegeAssignment(principal='sdk-irv696wx@example.com', privileges=[]), PrivilegeAssignment(principal='sdk-xh1hj2kq@example.com', privileges=[])]).privilege_assignments 11:21 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/ngMO 11:22 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s6tkp: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s6tkp 11:22 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_s6tkp', metastore_id=None, name='ucx_s6tkp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:22 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_s6tkp.ucx_tzmhy: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s6tkp/ucx_tzmhy 11:22 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=, 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_s6tkp.ucx_tzmhy', metastore_id=None, name='ucx_tzmhy', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='ucx_s6tkp', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/ngMO', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:22 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005776560, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwsmr', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cwsmr', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1720005776560, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:23 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cwsmr.ucx_s6tkp: https://DATABRICKS_HOST/explore/data/ucx_cwsmr/ucx_s6tkp 11:23 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cwsmr', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwsmr.ucx_s6tkp', metastore_id=None, name='ucx_s6tkp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw8] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 11:21 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/ngMO 11:22 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s6tkp: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s6tkp 11:22 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_s6tkp', metastore_id=None, name='ucx_s6tkp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:22 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_s6tkp.ucx_tzmhy: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s6tkp/ucx_tzmhy 11:22 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=, 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_s6tkp.ucx_tzmhy', metastore_id=None, name='ucx_tzmhy', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='ucx_s6tkp', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/ngMO', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:22 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005776560, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwsmr', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cwsmr', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1720005776560, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:23 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cwsmr.ucx_s6tkp: https://DATABRICKS_HOST/explore/data/ucx_cwsmr/ucx_s6tkp 11:23 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cwsmr', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwsmr.ucx_s6tkp', metastore_id=None, name='ucx_s6tkp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:23 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster fixture: 11:23 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-s3lwvie4@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-s3lwvie4@example.com')], entitlements=[], external_id=None, groups=[], id='8189808876575748', name=Name(family_name=None, given_name='sdk-s3lwvie4@example.com'), roles=[], schemas=[, ], user_name='sdk-s3lwvie4@example.com') 11:23 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster permissions fixture: 0703-112324-qe3wz18k [group_name admins CAN_MANAGE] -> [user_name sdk-s3lwvie4@example.com CAN_ATTACH_TO] 11:24 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sflxa: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sflxa 11:24 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_sflxa', metastore_id=None, name='ucx_sflxa', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Listing existing UC catalogs and schemas 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster fixture: 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-zlguejdf@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-zlguejdf@example.com')], entitlements=[], external_id=None, groups=[], id='3751660563005485', name=Name(family_name=None, given_name='sdk-zlguejdf@example.com'), roles=[], schemas=[, ], user_name='sdk-zlguejdf@example.com') 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster permissions fixture: 0703-112424-18bxkwr5 [group_name admins CAN_MANAGE] -> [user_name sdk-zlguejdf@example.com CAN_ATTACH_TO] 11:24 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Listing existing UC catalogs and schemas 11:25 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Preparing a list of UC catalogs and schema to be created 11:25 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_sflxa.tables] fetching tables inventory 11:25 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_sflxa.tables] crawling new batch for tables 11:25 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.ucx_s6tkp] listing tables 11:26 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.ucx_s6tkp.ucx_tzmhy] fetching table metadata 11:26 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_sflxa.tables] found 1 new records for tables 11:30 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-irv696wx@example.com` 11:30 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-eaherlxd@example.com` 11:31 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_G7DgP` 11:31 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GhRwx` 11:32 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GcIOr` 11:32 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-s3lwvie4@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-gxvlqwa4@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-euc3nmr9@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-nwemcpd2@example.com` 11:34 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GGVRT` 11:34 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-tkaex8ww@example.com` 11:34 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-bt6axp04@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-l2vwb8of@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GzUzp` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-yyea42ko@example.com` 11:36 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GLsT0` 11:36 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_G121N` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_G33Pi` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GrvOM` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GWmAu` 11:38 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GCJEx` 11:38 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-yco6fdtj@example.com` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-zjnttwkm@example.com` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `0a330eb5-dd51-4d97-b6e4-c474356b1d5d` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GngvU` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-xegrhhsh@example.com` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-y3roxcub@example.com` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-o2h7fcta@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-974tzeho@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-wffkk63f@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-f3plwvzn@example.com` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-gcgd4l7m@example.com` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `serge.smertin@databricks.com` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `5a11359f-ba1f-483f-8e00-0fe55ec003ed` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-uuabfxtt@example.com` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-xh1hj2kq@example.com` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-vfwdwjt5@example.com` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GJ1s7` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-6jnfibxx@example.com` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-j8rkrfjf@example.com` 11:45 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-wnz3c6fb@example.com` 11:45 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-nwemcpd2@example.com` 11:45 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-s3lwvie4@example.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-tkaex8ww@example.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-gxvlqwa4@example.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GLsT0` 11:47 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-eaherlxd@example.com` 11:47 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-xegrhhsh@example.com` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-wffkk63f@example.com` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_G121N` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-bt6axp04@example.com` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-yyea42ko@example.com` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_G33Pi` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `5a11359f-ba1f-483f-8e00-0fe55ec003ed` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GzUzp` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-y3roxcub@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-o2h7fcta@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-yco6fdtj@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GcIOr` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GrvOM` 11:51 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-wnz3c6fb@example.com` 11:51 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-l2vwb8of@example.com` 11:51 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-974tzeho@example.com` 11:51 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GJ1s7` 11:52 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-gcgd4l7m@example.com` 11:52 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GWmAu` 11:52 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-xh1hj2kq@example.com` 11:52 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `serge.smertin@databricks.com` 11:53 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-6jnfibxx@example.com` 11:53 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-euc3nmr9@example.com` 11:54 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GGVRT` 11:54 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-zjnttwkm@example.com` 11:54 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GhRwx` 11:54 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GngvU` 11:55 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_G7DgP` 11:55 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-vfwdwjt5@example.com` 11:55 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-f3plwvzn@example.com` 11:55 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-j8rkrfjf@example.com` 11:55 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-uuabfxtt@example.com` 11:56 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GCJEx` 11:56 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `0a330eb5-dd51-4d97-b6e4-c474356b1d5d` 11:56 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-irv696wx@example.com` 11:21 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/ngMO 11:22 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_s6tkp: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s6tkp 11:22 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_s6tkp', metastore_id=None, name='ucx_s6tkp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:22 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_s6tkp.ucx_tzmhy: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_s6tkp/ucx_tzmhy 11:22 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=, 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_s6tkp.ucx_tzmhy', metastore_id=None, name='ucx_tzmhy', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='ucx_s6tkp', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/ngMO', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:22 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005776560, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwsmr', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cwsmr', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1720005776560, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:23 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cwsmr.ucx_s6tkp: https://DATABRICKS_HOST/explore/data/ucx_cwsmr/ucx_s6tkp 11:23 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cwsmr', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwsmr.ucx_s6tkp', metastore_id=None, name='ucx_s6tkp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:23 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster fixture: 11:23 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-s3lwvie4@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-s3lwvie4@example.com')], entitlements=[], external_id=None, groups=[], id='8189808876575748', name=Name(family_name=None, given_name='sdk-s3lwvie4@example.com'), roles=[], schemas=[, ], user_name='sdk-s3lwvie4@example.com') 11:23 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster permissions fixture: 0703-112324-qe3wz18k [group_name admins CAN_MANAGE] -> [user_name sdk-s3lwvie4@example.com CAN_ATTACH_TO] 11:24 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sflxa: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sflxa 11:24 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_sflxa', metastore_id=None, name='ucx_sflxa', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:24 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Listing existing UC catalogs and schemas 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster fixture: 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-zlguejdf@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-zlguejdf@example.com')], entitlements=[], external_id=None, groups=[], id='3751660563005485', name=Name(family_name=None, given_name='sdk-zlguejdf@example.com'), roles=[], schemas=[, ], user_name='sdk-zlguejdf@example.com') 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster permissions fixture: 0703-112424-18bxkwr5 [group_name admins CAN_MANAGE] -> [user_name sdk-zlguejdf@example.com CAN_ATTACH_TO] 11:24 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Listing existing UC catalogs and schemas 11:25 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Preparing a list of UC catalogs and schema to be created 11:25 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_sflxa.tables] fetching tables inventory 11:25 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_sflxa.tables] crawling new batch for tables 11:25 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.ucx_s6tkp] listing tables 11:26 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.ucx_s6tkp.ucx_tzmhy] fetching table metadata 11:26 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_sflxa.tables] found 1 new records for tables 11:30 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-irv696wx@example.com` 11:30 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-eaherlxd@example.com` 11:31 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_G7DgP` 11:31 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GhRwx` 11:32 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GcIOr` 11:32 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-s3lwvie4@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-gxvlqwa4@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-euc3nmr9@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-nwemcpd2@example.com` 11:34 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GGVRT` 11:34 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-tkaex8ww@example.com` 11:34 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-bt6axp04@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-l2vwb8of@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GzUzp` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-yyea42ko@example.com` 11:36 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GLsT0` 11:36 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_G121N` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_G33Pi` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GrvOM` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GWmAu` 11:38 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GCJEx` 11:38 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-yco6fdtj@example.com` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-zjnttwkm@example.com` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `0a330eb5-dd51-4d97-b6e4-c474356b1d5d` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GngvU` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-xegrhhsh@example.com` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-y3roxcub@example.com` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-o2h7fcta@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-974tzeho@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-wffkk63f@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-f3plwvzn@example.com` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-gcgd4l7m@example.com` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `serge.smertin@databricks.com` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `5a11359f-ba1f-483f-8e00-0fe55ec003ed` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-uuabfxtt@example.com` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-xh1hj2kq@example.com` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-vfwdwjt5@example.com` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `ucx_GJ1s7` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-6jnfibxx@example.com` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-j8rkrfjf@example.com` 11:45 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cwsmr.ucx_s6tkp') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cwsmr.ucx_s6tkp TO `sdk-wnz3c6fb@example.com` 11:45 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-nwemcpd2@example.com` 11:45 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-s3lwvie4@example.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-tkaex8ww@example.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-gxvlqwa4@example.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GLsT0` 11:47 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-eaherlxd@example.com` 11:47 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-xegrhhsh@example.com` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-wffkk63f@example.com` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_G121N` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-bt6axp04@example.com` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-yyea42ko@example.com` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_G33Pi` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `5a11359f-ba1f-483f-8e00-0fe55ec003ed` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GzUzp` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-y3roxcub@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-o2h7fcta@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-yco6fdtj@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GcIOr` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GrvOM` 11:51 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-wnz3c6fb@example.com` 11:51 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-l2vwb8of@example.com` 11:51 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-974tzeho@example.com` 11:51 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GJ1s7` 11:52 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-gcgd4l7m@example.com` 11:52 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GWmAu` 11:52 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-xh1hj2kq@example.com` 11:52 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `serge.smertin@databricks.com` 11:53 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-6jnfibxx@example.com` 11:53 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-euc3nmr9@example.com` 11:54 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GGVRT` 11:54 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-zjnttwkm@example.com` 11:54 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GhRwx` 11:54 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GngvU` 11:55 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_G7DgP` 11:55 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-vfwdwjt5@example.com` 11:55 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-f3plwvzn@example.com` 11:55 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-j8rkrfjf@example.com` 11:55 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-uuabfxtt@example.com` 11:56 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `ucx_GCJEx` 11:56 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `0a330eb5-dd51-4d97-b6e4-c474356b1d5d` 11:56 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cwsmr') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cwsmr TO `sdk-irv696wx@example.com` 11:56 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 cluster permissions fixtures 11:56 DEBUG [databricks.labs.ucx.mixins.fixtures] removing cluster permissions fixture: 0703-112324-qe3wz18k [group_name admins CAN_MANAGE] -> [user_name sdk-s3lwvie4@example.com CAN_ATTACH_TO] 11:56 DEBUG [databricks.labs.ucx.mixins.fixtures] removing cluster permissions fixture: 0703-112424-18bxkwr5 [group_name admins CAN_MANAGE] -> [user_name sdk-zlguejdf@example.com CAN_ATTACH_TO] 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005776560, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwsmr', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cwsmr', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1720005776560, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/ngMO 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 cluster fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing cluster fixture: 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing cluster fixture: 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 table fixtures 11:57 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=, 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_s6tkp.ucx_tzmhy', metastore_id=None, name='ucx_tzmhy', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='ucx_s6tkp', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/ngMO', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures 11:57 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_s6tkp', metastore_id=None, name='ucx_s6tkp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:57 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cwsmr', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwsmr.ucx_s6tkp', metastore_id=None, name='ucx_s6tkp', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:58 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_sflxa', metastore_id=None, name='ucx_sflxa', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:58 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 workspace user fixtures 11:58 DEBUG [databricks.labs.ucx.mixins.fixtures] removing workspace user fixture: User(active=True, display_name='sdk-s3lwvie4@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-s3lwvie4@example.com')], entitlements=[], external_id=None, groups=[], id='8189808876575748', name=Name(family_name=None, given_name='sdk-s3lwvie4@example.com'), roles=[], schemas=[, ], user_name='sdk-s3lwvie4@example.com') 11:58 DEBUG [databricks.labs.ucx.mixins.fixtures] removing workspace user fixture: User(active=True, display_name='sdk-zlguejdf@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-zlguejdf@example.com')], entitlements=[], external_id=None, groups=[], id='3751660563005485', name=Name(family_name=None, given_name='sdk-zlguejdf@example.com'), roles=[], schemas=[, ], user_name='sdk-zlguejdf@example.com') [gw8] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```

Running from acceptance #4282