databrickslabs / ucx

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

whitelist momentfm #2056

Closed ericvergnaud closed 2 months ago

ericvergnaud commented 3 months ago

Changes

whitelist momentfm

Linked issues

Progresses #1901

Functionality

None

Tests

github-actions[bot] commented 3 months ago

❌ 83/88 passed, 5 failed, 18 skipped, 5h43m49s total

❌ test_run_validate_acl: databricks.sdk.errors.platform.BadRequest: [SCHEMA_ALREADY_EXISTS] Cannot create schema `ucx_s4atq` because it already exists. (21.36s) ``` databricks.sdk.errors.platform.BadRequest: [SCHEMA_ALREADY_EXISTS] Cannot create schema `ucx_s4atq` because it already exists. Choose a different name, drop the existing schema, or add the IF NOT EXISTS clause to tolerate pre-existing schema. SQLSTATE: 42P06 [gw7] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 11:13 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 schema fixtures 11:13 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 cluster fixtures 11:13 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace user fixtures 11:13 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 cluster permissions fixtures [gw7] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```
❌ test_group: TimeoutError: Timed out after 0:00:30 (32.318s) ``` TimeoutError: Timed out after 0:00:30 [gw9] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 11:13 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-rokiwjpx@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-rokiwjpx@example.com')], entitlements=[], external_id=None, groups=[], id='1333289332711423', name=Name(family_name=None, given_name='sdk-rokiwjpx@example.com'), roles=[], schemas=[, ], user_name='sdk-rokiwjpx@example.com') 11:13 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-rokiwjpx@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-rokiwjpx@example.com')], entitlements=[], external_id=None, groups=[], id='1333289332711423', name=Name(family_name=None, given_name='sdk-rokiwjpx@example.com'), roles=[], schemas=[, ], user_name='sdk-rokiwjpx@example.com') 11:13 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 workspace user fixtures 11:13 DEBUG [databricks.labs.ucx.mixins.fixtures] removing workspace user fixture: User(active=True, display_name='sdk-rokiwjpx@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-rokiwjpx@example.com')], entitlements=[], external_id=None, groups=[], id='1333289332711423', name=Name(family_name=None, given_name='sdk-rokiwjpx@example.com'), roles=[], schemas=[, ], user_name='sdk-rokiwjpx@example.com') 11:13 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures [gw9] 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 (17m59.614s) ``` TimeoutError: Timed out after 0:05:00 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/1Ehh 11:24 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w 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.hiveserde_in_place_ysq0w', metastore_id=None, name='hiveserde_in_place_ysq0w', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w 11:25 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ysq0w.parquet_serde_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w/parquet_serde_ysq0w 11:25 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_ysq0w.parquet_serde_ysq0w', metastore_id=None, name='parquet_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/parquet_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:25 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ysq0w.orc_serde_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w/orc_serde_ysq0w 11:25 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_ysq0w.orc_serde_ysq0w', metastore_id=None, name='orc_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/orc_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:26 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ysq0w.avro_serde_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w/avro_serde_ysq0w 11:26 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_ysq0w.avro_serde_ysq0w', metastore_id=None, name='avro_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/avro_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:26 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005988533, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cbwbz', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cbwbz', 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=1720005988533, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:26 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cbwbz.hiveserde_in_place_ysq0w: https://DATABRICKS_HOST/explore/data/ucx_cbwbz/hiveserde_in_place_ysq0w 11:26 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cbwbz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cbwbz.hiveserde_in_place_ysq0w', metastore_id=None, name='hiveserde_in_place_ysq0w', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:28 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sfcp4: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sfcp4 11:28 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_sfcp4', metastore_id=None, name='ucx_sfcp4', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw3] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/1Ehh 11:24 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w 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.hiveserde_in_place_ysq0w', metastore_id=None, name='hiveserde_in_place_ysq0w', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w 11:25 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ysq0w.parquet_serde_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w/parquet_serde_ysq0w 11:25 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_ysq0w.parquet_serde_ysq0w', metastore_id=None, name='parquet_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/parquet_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:25 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ysq0w.orc_serde_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w/orc_serde_ysq0w 11:25 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_ysq0w.orc_serde_ysq0w', metastore_id=None, name='orc_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/orc_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:26 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ysq0w.avro_serde_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w/avro_serde_ysq0w 11:26 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_ysq0w.avro_serde_ysq0w', metastore_id=None, name='avro_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/avro_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:26 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005988533, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cbwbz', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cbwbz', 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=1720005988533, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:26 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cbwbz.hiveserde_in_place_ysq0w: https://DATABRICKS_HOST/explore/data/ucx_cbwbz/hiveserde_in_place_ysq0w 11:26 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cbwbz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cbwbz.hiveserde_in_place_ysq0w', metastore_id=None, name='hiveserde_in_place_ysq0w', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:28 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sfcp4: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sfcp4 11:28 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_sfcp4', metastore_id=None, name='ucx_sfcp4', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:32 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Qqz8/config.yml) doesn't exist. 11:32 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 11:32 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:32 INFO [databricks.labs.ucx.install] Fetching installations... 11:32 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Qqz8 is corrupted. Skipping... 11:32 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 11:32 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:32 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:32 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+7020240703113220 11:32 INFO [databricks.labs.ucx.install] Creating ucx schemas... 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 11:35 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Qqz8/README for the next steps. 11:35 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-tables-ctas job: https://DATABRICKS_HOST#job/231256057245236 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/1Ehh 11:24 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.hiveserde_in_place_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w 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.hiveserde_in_place_ysq0w', metastore_id=None, name='hiveserde_in_place_ysq0w', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:24 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w 11:25 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ysq0w.parquet_serde_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w/parquet_serde_ysq0w 11:25 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_ysq0w.parquet_serde_ysq0w', metastore_id=None, name='parquet_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/parquet_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:25 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ysq0w.orc_serde_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w/orc_serde_ysq0w 11:25 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_ysq0w.orc_serde_ysq0w', metastore_id=None, name='orc_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/orc_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:26 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.hiveserde_in_place_ysq0w.avro_serde_ysq0w: https://DATABRICKS_HOST/explore/data/hive_metastore/hiveserde_in_place_ysq0w/avro_serde_ysq0w 11:26 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_ysq0w.avro_serde_ysq0w', metastore_id=None, name='avro_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/avro_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:26 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005988533, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cbwbz', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cbwbz', 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=1720005988533, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:26 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cbwbz.hiveserde_in_place_ysq0w: https://DATABRICKS_HOST/explore/data/ucx_cbwbz/hiveserde_in_place_ysq0w 11:26 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cbwbz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cbwbz.hiveserde_in_place_ysq0w', metastore_id=None, name='hiveserde_in_place_ysq0w', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:28 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sfcp4: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sfcp4 11:28 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_sfcp4', metastore_id=None, name='ucx_sfcp4', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:32 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Qqz8/config.yml) doesn't exist. 11:32 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 11:32 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:32 INFO [databricks.labs.ucx.install] Fetching installations... 11:32 WARNING [databricks.labs.ucx.install] Existing installation at /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Qqz8 is corrupted. Skipping... 11:32 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 11:32 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:32 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:32 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+7020240703113220 11:32 INFO [databricks.labs.ucx.install] Creating ucx schemas... 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 11:35 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 11:35 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.Qqz8/README for the next steps. 11:35 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-external-tables-ctas job: https://DATABRICKS_HOST#job/231256057245236 11:39 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_storage_dir fixtures 11:39 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_storage_dir fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w 11:39 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures 11:39 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/1Ehh 11:39 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 cluster fixtures 11:39 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures 11:39 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005988533, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cbwbz', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cbwbz', 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=1720005988533, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:39 INFO [databricks.labs.ucx.install] Deleting UCX v0.27.2+7020240703113220 from https://DATABRICKS_HOST 11:39 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_sfcp4 11:40 INFO [databricks.labs.ucx.install] Deleting jobs 11:40 INFO [databricks.labs.ucx.install] Deleting failing job_id=1007679179397873. 11:40 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=912372796464001. 11:40 INFO [databricks.labs.ucx.install] Deleting migrate-external-tables-ctas job_id=231256057245236. 11:40 INFO [databricks.labs.ucx.install] Deleting migrate-groups-experimental job_id=93154796719171. 11:40 INFO [databricks.labs.ucx.install] Deleting migrate-tables-in-mounts-experimental job_id=557458980859037. 11:40 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=928782015710209. 11:40 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=1029069334211484. 11:40 INFO [databricks.labs.ucx.install] Deleting scan-tables-in-mounts-experimental job_id=1038655821023683. 11:40 INFO [databricks.labs.ucx.install] Deleting assessment job_id=785857640353242. 11:40 INFO [databricks.labs.ucx.install] Deleting migrate-external-hiveserde-tables-in-place-experimental job_id=613501262053170. 11:40 INFO [databricks.labs.ucx.install] Deleting migrate-data-reconciliation job_id=1070577793863476. 11:40 INFO [databricks.labs.ucx.install] Deleting experimental-workflow-linter job_id=856617553960624. 11:40 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=259189740648133. 11:40 INFO [databricks.labs.ucx.install] Deleting cluster policy 11:40 INFO [databricks.labs.ucx.install] Deleting secret scope 11:40 INFO [databricks.labs.ucx.install] UnInstalling UCX complete 11:40 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace user fixtures 11:40 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 account group fixtures 11:40 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 11:40 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 11:40 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 table fixtures 11:40 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_ysq0w.parquet_serde_ysq0w', metastore_id=None, name='parquet_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/parquet_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:40 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_ysq0w.orc_serde_ysq0w', metastore_id=None, name='orc_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/orc_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:40 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_ysq0w.avro_serde_ysq0w', metastore_id=None, name='avro_serde_ysq0w', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='hiveserde_in_place_ysq0w', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/hiveserde_in_place_ysq0w/avro_serde_ysq0w', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:41 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures 11:41 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_ysq0w', metastore_id=None, name='hiveserde_in_place_ysq0w', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:41 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cbwbz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cbwbz.hiveserde_in_place_ysq0w', metastore_id=None, name='hiveserde_in_place_ysq0w', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:41 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_sfcp4', metastore_id=None, name='ucx_sfcp4', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw3] 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 (9m15.133s) ``` TimeoutError: Timed out after 0:02:00 [gw4] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python 11:42 DEBUG [databricks.labs.ucx.mixins.fixtures] added directory fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ldxv 11:42 DEBUG [databricks.labs.ucx.mixins.fixtures] added notebook fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ldxv/notebook.ipynb 11:42 INFO [databricks.labs.ucx.mixins.fixtures] Job: https://DATABRICKS_HOST#job/652948388598564 11:42 DEBUG [databricks.labs.ucx.mixins.fixtures] added job fixture: CreateResponse(job_id=652948388598564) 11:42 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_spy2b: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_spy2b 11:42 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_spy2b', metastore_id=None, name='ucx_spy2b', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:42 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.pCua/config.yml) doesn't exist. 11:42 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 11:42 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:42 INFO [databricks.labs.ucx.install] Fetching installations... 11:43 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 11:43 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:43 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:43 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+7020240703114302 11:43 INFO [databricks.labs.ucx.install] Creating ucx schemas... 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 11:46 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.pCua/README for the next steps. 11:46 DEBUG [databricks.labs.ucx.installer.workflows] starting experimental-workflow-linter job: https://DATABRICKS_HOST#job/434495338960662 11:50 DEBUG [databricks.labs.ucx.installer.workflows] Validating experimental-workflow-linter workflow: https://DATABRICKS_HOST#job/434495338960662 11:42 DEBUG [databricks.labs.ucx.mixins.fixtures] added directory fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ldxv 11:42 DEBUG [databricks.labs.ucx.mixins.fixtures] added notebook fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ldxv/notebook.ipynb 11:42 INFO [databricks.labs.ucx.mixins.fixtures] Job: https://DATABRICKS_HOST#job/652948388598564 11:42 DEBUG [databricks.labs.ucx.mixins.fixtures] added job fixture: CreateResponse(job_id=652948388598564) 11:42 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_spy2b: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_spy2b 11:42 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_spy2b', metastore_id=None, name='ucx_spy2b', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:42 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.pCua/config.yml) doesn't exist. 11:42 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration 11:42 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:42 INFO [databricks.labs.ucx.install] Fetching installations... 11:43 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy. 11:43 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:43 DEBUG [tests.integration.conftest] Waiting for clusters to start... 11:43 INFO [databricks.labs.ucx.install] Installing UCX v0.27.2+7020240703114302 11:43 INFO [databricks.labs.ucx.install] Creating ucx schemas... 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-data-reconciliation 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=failing 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=experimental-workflow-linter 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-hiveserde-tables-in-place-experimental 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables-in-mounts-experimental 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=scan-tables-in-mounts-experimental 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups-experimental 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables 11:46 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-external-tables-ctas 11:46 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.pCua/README for the next steps. 11:46 DEBUG [databricks.labs.ucx.installer.workflows] starting experimental-workflow-linter job: https://DATABRICKS_HOST#job/434495338960662 11:50 DEBUG [databricks.labs.ucx.installer.workflows] Validating experimental-workflow-linter workflow: https://DATABRICKS_HOST#job/434495338960662 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 job fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] removing job fixture: CreateResponse(job_id=652948388598564) 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 directory fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] removing directory fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ldxv 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 notebook fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] removing notebook fixture: /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ldxv/notebook.ipynb 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while notebook /Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ldxv/notebook.ipynb teardown: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/sdk-ldxv/notebook.ipynb) doesn't exist. 11:51 INFO [databricks.labs.ucx.install] Deleting UCX v0.27.2+7020240703114302 from https://DATABRICKS_HOST 11:51 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_spy2b 11:51 INFO [databricks.labs.ucx.install] Deleting jobs 11:51 INFO [databricks.labs.ucx.install] Deleting assessment job_id=597959262905348. 11:51 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=695935322903538. 11:51 INFO [databricks.labs.ucx.install] Deleting migrate-data-reconciliation job_id=507759204664718. 11:51 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=282066333325434. 11:51 INFO [databricks.labs.ucx.install] Deleting failing job_id=660926071743358. 11:51 INFO [databricks.labs.ucx.install] Deleting experimental-workflow-linter job_id=434495338960662. 11:51 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=363112449277352. 11:51 INFO [databricks.labs.ucx.install] Deleting migrate-external-hiveserde-tables-in-place-experimental job_id=323967338357913. 11:51 INFO [databricks.labs.ucx.install] Deleting migrate-tables-in-mounts-experimental job_id=1071517481330499. 11:51 INFO [databricks.labs.ucx.install] Deleting scan-tables-in-mounts-experimental job_id=832642582230979. 11:51 INFO [databricks.labs.ucx.install] Deleting migrate-groups-experimental job_id=296679217068859. 11:51 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=316731590760295. 11:51 INFO [databricks.labs.ucx.install] Deleting migrate-external-tables-ctas job_id=1070229134292350. 11:51 INFO [databricks.labs.ucx.install] Deleting cluster policy 11:51 INFO [databricks.labs.ucx.install] Deleting secret scope 11:51 INFO [databricks.labs.ucx.install] UnInstalling UCX complete 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace user fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 account group fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 schema fixtures 11:51 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_spy2b', metastore_id=None, name='ucx_spy2b', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) [gw4] 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-xegrhhsh@example.com', privileges=[]) in [PrivilegeAssignment(principal='sdk-irv696wx@example.com', privileges=[]), Privile...>]), PrivilegeAssignment(principal='sdk-gxvlqwa4@example.com', privileges=[]), ...] (36m45.792s) ``` AssertionError: assert PrivilegeAssignment(principal='sdk-xegrhhsh@example.com', privileges=[]) in [PrivilegeAssignment(principal='sdk-irv696wx@example.com', privileges=[]), Privile...>]), PrivilegeAssignment(principal='sdk-gxvlqwa4@example.com', privileges=[]), ...] + where [PrivilegeAssignment(principal='sdk-irv696wx@example.com', privileges=[]), Privile...>]), PrivilegeAssignment(principal='sdk-gxvlqwa4@example.com', privileges=[]), ...] = PermissionsList(privilege_assignments=[PrivilegeAssignment(principal='sdk-irv696wx@example.com', privileges=[]), PrivilegeAssignment(principal='sdk-xh1hj2kq@example.com', privileges=[])]).privilege_assignments 11:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/Nt2M 11:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_snp0v: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_snp0v 11:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_snp0v', metastore_id=None, name='ucx_snp0v', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:16 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_snp0v.ucx_tgx8d: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_snp0v/ucx_tgx8d 11:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=, 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_snp0v.ucx_tgx8d', metastore_id=None, name='ucx_tgx8d', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='ucx_snp0v', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/Nt2M', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005424567, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cyn6q', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cyn6q', 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=1720005424567, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cyn6q.ucx_snp0v: https://DATABRICKS_HOST/explore/data/ucx_cyn6q/ucx_snp0v 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cyn6q', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cyn6q.ucx_snp0v', metastore_id=None, name='ucx_snp0v', 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:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/Nt2M 11:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_snp0v: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_snp0v 11:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_snp0v', metastore_id=None, name='ucx_snp0v', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:16 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_snp0v.ucx_tgx8d: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_snp0v/ucx_tgx8d 11:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=, 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_snp0v.ucx_tgx8d', metastore_id=None, name='ucx_tgx8d', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='ucx_snp0v', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/Nt2M', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005424567, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cyn6q', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cyn6q', 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=1720005424567, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cyn6q.ucx_snp0v: https://DATABRICKS_HOST/explore/data/ucx_cyn6q/ucx_snp0v 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cyn6q', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cyn6q.ucx_snp0v', metastore_id=None, name='ucx_snp0v', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster fixture: 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-y3roxcub@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-y3roxcub@example.com')], entitlements=[], external_id=None, groups=[], id='6577128680281770', name=Name(family_name=None, given_name='sdk-y3roxcub@example.com'), roles=[], schemas=[, ], user_name='sdk-y3roxcub@example.com') 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster permissions fixture: 0703-111735-ighmzfkr [group_name admins CAN_MANAGE] -> [user_name sdk-y3roxcub@example.com CAN_ATTACH_TO] 11:18 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_scjwl: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_scjwl 11:18 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_scjwl', metastore_id=None, name='ucx_scjwl', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Listing existing UC catalogs and schemas 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster fixture: 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-xegrhhsh@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-xegrhhsh@example.com')], entitlements=[], external_id=None, groups=[], id='8294862579820567', name=Name(family_name=None, given_name='sdk-xegrhhsh@example.com'), roles=[], schemas=[, ], user_name='sdk-xegrhhsh@example.com') 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster permissions fixture: 0703-111827-jtygviy0 [group_name admins CAN_MANAGE] -> [user_name sdk-xegrhhsh@example.com CAN_ATTACH_TO] 11:18 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Listing existing UC catalogs and schemas 11:18 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Preparing a list of UC catalogs and schema to be created 11:18 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_scjwl.tables] fetching tables inventory 11:19 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_scjwl.tables] crawling new batch for tables 11:19 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.ucx_snp0v] listing tables 11:19 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.ucx_snp0v.ucx_tgx8d] fetching table metadata 11:20 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_scjwl.tables] found 1 new records for tables 11:24 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GGVRT` 11:24 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_G7DgP` 11:25 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-wffkk63f@example.com` 11:25 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-gcgd4l7m@example.com` 11:26 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-zjnttwkm@example.com` 11:26 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_G33Pi` 11:26 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_G121N` 11:27 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `5a11359f-ba1f-483f-8e00-0fe55ec003ed` 11:27 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-y3roxcub@example.com` 11:28 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-wnz3c6fb@example.com` 11:28 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-j8rkrfjf@example.com` 11:29 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GrvOM` 11:29 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-nwemcpd2@example.com` 11:29 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-sqpoyeqz@example.com` 11:30 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GCJEx` 11:30 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GhRwx` 11:31 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-yco6fdtj@example.com` 11:31 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `serge.smertin@databricks.com` 11:32 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GcIOr` 11:32 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-xh1hj2kq@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-euc3nmr9@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-o2h7fcta@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `0a330eb5-dd51-4d97-b6e4-c474356b1d5d` 11:34 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-irv696wx@example.com` 11:34 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-eaherlxd@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-974tzeho@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-bt6axp04@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-yyea42ko@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-l2vwb8of@example.com` 11:36 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-gxvlqwa4@example.com` 11:36 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-f3plwvzn@example.com` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GngvU` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-tkaex8ww@example.com` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GzUzp` 11:38 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GJ1s7` 11:38 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-vfwdwjt5@example.com` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GLsT0` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-f3plwvzn@example.com` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_G7DgP` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-vfwdwjt5@example.com` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GJ1s7` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-yyea42ko@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-o2h7fcta@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-euc3nmr9@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-eaherlxd@example.com` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GcIOr` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_G33Pi` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GLsT0` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GhRwx` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-wffkk63f@example.com` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GngvU` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GCJEx` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-974tzeho@example.com` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-irv696wx@example.com` 11:45 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-gcgd4l7m@example.com` 11:45 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-sqpoyeqz@example.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-wnz3c6fb@example.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `serge.smertin@databricks.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GrvOM` 11:47 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-nwemcpd2@example.com` 11:47 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-zjnttwkm@example.com` 11:47 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `5a11359f-ba1f-483f-8e00-0fe55ec003ed` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-yco6fdtj@example.com` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-y3roxcub@example.com` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GzUzp` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_G121N` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-j8rkrfjf@example.com` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-xh1hj2kq@example.com` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-tkaex8ww@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-l2vwb8of@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-bt6axp04@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `0a330eb5-dd51-4d97-b6e4-c474356b1d5d` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GGVRT` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-gxvlqwa4@example.com` 11:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/Nt2M 11:16 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_snp0v: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_snp0v 11:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_snp0v', metastore_id=None, name='ucx_snp0v', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:16 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_snp0v.ucx_tgx8d: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_snp0v/ucx_tgx8d 11:16 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=, 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_snp0v.ucx_tgx8d', metastore_id=None, name='ucx_tgx8d', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='ucx_snp0v', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/Nt2M', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005424567, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cyn6q', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cyn6q', 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=1720005424567, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cyn6q.ucx_snp0v: https://DATABRICKS_HOST/explore/data/ucx_cyn6q/ucx_snp0v 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cyn6q', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cyn6q.ucx_snp0v', metastore_id=None, name='ucx_snp0v', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster fixture: 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-y3roxcub@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-y3roxcub@example.com')], entitlements=[], external_id=None, groups=[], id='6577128680281770', name=Name(family_name=None, given_name='sdk-y3roxcub@example.com'), roles=[], schemas=[, ], user_name='sdk-y3roxcub@example.com') 11:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster permissions fixture: 0703-111735-ighmzfkr [group_name admins CAN_MANAGE] -> [user_name sdk-y3roxcub@example.com CAN_ATTACH_TO] 11:18 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_scjwl: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_scjwl 11:18 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_scjwl', metastore_id=None, name='ucx_scjwl', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 WARNING [databricks.labs.ucx.assessment.secrets] Secret in config stored in plaintext. 11:18 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Listing existing UC catalogs and schemas 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster fixture: 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] added workspace user fixture: User(active=True, display_name='sdk-xegrhhsh@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-xegrhhsh@example.com')], entitlements=[], external_id=None, groups=[], id='8294862579820567', name=Name(family_name=None, given_name='sdk-xegrhhsh@example.com'), roles=[], schemas=[, ], user_name='sdk-xegrhhsh@example.com') 11:18 DEBUG [databricks.labs.ucx.mixins.fixtures] added cluster permissions fixture: 0703-111827-jtygviy0 [group_name admins CAN_MANAGE] -> [user_name sdk-xegrhhsh@example.com CAN_ATTACH_TO] 11:18 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Listing existing UC catalogs and schemas 11:18 INFO [databricks.labs.ucx.hive_metastore.catalog_schema] Preparing a list of UC catalogs and schema to be created 11:18 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_scjwl.tables] fetching tables inventory 11:19 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_scjwl.tables] crawling new batch for tables 11:19 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.ucx_snp0v] listing tables 11:19 DEBUG [databricks.labs.ucx.hive_metastore.tables] [hive_metastore.ucx_snp0v.ucx_tgx8d] fetching table metadata 11:20 DEBUG [databricks.labs.ucx.framework.crawlers] [hive_metastore.ucx_scjwl.tables] found 1 new records for tables 11:24 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GGVRT` 11:24 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_G7DgP` 11:25 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-wffkk63f@example.com` 11:25 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-gcgd4l7m@example.com` 11:26 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-zjnttwkm@example.com` 11:26 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_G33Pi` 11:26 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_G121N` 11:27 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `5a11359f-ba1f-483f-8e00-0fe55ec003ed` 11:27 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-y3roxcub@example.com` 11:28 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-wnz3c6fb@example.com` 11:28 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-j8rkrfjf@example.com` 11:29 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GrvOM` 11:29 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-nwemcpd2@example.com` 11:29 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-sqpoyeqz@example.com` 11:30 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GCJEx` 11:30 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GhRwx` 11:31 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-yco6fdtj@example.com` 11:31 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `serge.smertin@databricks.com` 11:32 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GcIOr` 11:32 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-xh1hj2kq@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-euc3nmr9@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-o2h7fcta@example.com` 11:33 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `0a330eb5-dd51-4d97-b6e4-c474356b1d5d` 11:34 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-irv696wx@example.com` 11:34 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-eaherlxd@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-974tzeho@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-bt6axp04@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-yyea42ko@example.com` 11:35 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-l2vwb8of@example.com` 11:36 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-gxvlqwa4@example.com` 11:36 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-f3plwvzn@example.com` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GngvU` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-tkaex8ww@example.com` 11:37 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GzUzp` 11:38 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GJ1s7` 11:38 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `sdk-vfwdwjt5@example.com` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('DATABASE', 'ucx_cyn6q.ucx_snp0v') using SQL query: GRANT USE SCHEMA ON DATABASE ucx_cyn6q.ucx_snp0v TO `ucx_GLsT0` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-f3plwvzn@example.com` 11:39 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_G7DgP` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-vfwdwjt5@example.com` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GJ1s7` 11:40 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-yyea42ko@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-o2h7fcta@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-euc3nmr9@example.com` 11:41 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-eaherlxd@example.com` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GcIOr` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_G33Pi` 11:42 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GLsT0` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GhRwx` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-wffkk63f@example.com` 11:43 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GngvU` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GCJEx` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-974tzeho@example.com` 11:44 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-irv696wx@example.com` 11:45 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-gcgd4l7m@example.com` 11:45 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-sqpoyeqz@example.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-wnz3c6fb@example.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `serge.smertin@databricks.com` 11:46 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GrvOM` 11:47 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-nwemcpd2@example.com` 11:47 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-zjnttwkm@example.com` 11:47 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `5a11359f-ba1f-483f-8e00-0fe55ec003ed` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-yco6fdtj@example.com` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-y3roxcub@example.com` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GzUzp` 11:48 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_G121N` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-j8rkrfjf@example.com` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-xh1hj2kq@example.com` 11:49 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-tkaex8ww@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-l2vwb8of@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-bt6axp04@example.com` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `0a330eb5-dd51-4d97-b6e4-c474356b1d5d` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `ucx_GGVRT` 11:50 DEBUG [databricks.labs.ucx.hive_metastore.catalog_schema] Migrating acls on ('CATALOG', 'ucx_cyn6q') using SQL query: GRANT USE CATALOG ON CATALOG ucx_cyn6q TO `sdk-gxvlqwa4@example.com` 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 cluster permissions fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] removing cluster permissions fixture: 0703-111735-ighmzfkr [group_name admins CAN_MANAGE] -> [user_name sdk-y3roxcub@example.com CAN_ATTACH_TO] 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] removing cluster permissions fixture: 0703-111827-jtygviy0 [group_name admins CAN_MANAGE] -> [user_name sdk-xegrhhsh@example.com CAN_ATTACH_TO] 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=, comment='', connection_name=None, created_at=1720005424567, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cyn6q', isolation_mode=, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cyn6q', 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=1720005424567, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d') 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/Nt2M 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 cluster fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] removing cluster fixture: 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] removing cluster fixture: 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 workspace group fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 table fixtures 11:51 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_snp0v.ucx_tgx8d', metastore_id=None, name='ucx_tgx8d', owner=None, pipeline_id=None, properties={'RemoveAfter': '2024070312'}, row_filter=None, schema_name='ucx_snp0v', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/Nt2M', table_constraints=None, table_id=None, table_type=, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None) 11:51 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures 11:51 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_snp0v', metastore_id=None, name='ucx_snp0v', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:52 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cyn6q', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cyn6q.ucx_snp0v', metastore_id=None, name='ucx_snp0v', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:52 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_scjwl', metastore_id=None, name='ucx_scjwl', owner=None, properties=None, schema_id=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None) 11:52 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 workspace user fixtures 11:52 DEBUG [databricks.labs.ucx.mixins.fixtures] removing workspace user fixture: User(active=True, display_name='sdk-y3roxcub@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-y3roxcub@example.com')], entitlements=[], external_id=None, groups=[], id='6577128680281770', name=Name(family_name=None, given_name='sdk-y3roxcub@example.com'), roles=[], schemas=[, ], user_name='sdk-y3roxcub@example.com') 11:52 DEBUG [databricks.labs.ucx.mixins.fixtures] removing workspace user fixture: User(active=True, display_name='sdk-xegrhhsh@example.com', emails=[ComplexValue(display=None, primary=True, ref=None, type='work', value='sdk-xegrhhsh@example.com')], entitlements=[], external_id=None, groups=[], id='8294862579820567', name=Name(family_name=None, given_name='sdk-xegrhhsh@example.com'), roles=[], schemas=[, ], user_name='sdk-xegrhhsh@example.com') [gw8] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python ```

Running from acceptance #4280