Temporarily disabled tests that do not work on aws by nkvuong · Pull Request #1377 · databrickslabs/ucx

nkvuong · 2024-04-12T09:36:08Z

Changes

Temporarily disabled tests that do not work on AWS, for 2 reasons:

make_dbfs_data_copy does not work with mounts on aws
principal_acl does not have aws implementation yet

Tests

manually tested
verified on staging environment (screenshot attached)

github-actions · 2024-04-12T10:03:17Z

❌ 138/140 passed, 2 flaky, 2 failed, 20 skipped, 1h18m58s total

❌ test_migrate_view: TimeoutError: Timed out after 0:02:00 (2m42.185s)

TimeoutError: Timed out after 0:02:00
[gw6] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_strqz: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_strqz
10:47 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_strqz', metastore_id=None, name='ucx_strqz', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_strqz.ucx_tevib: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_strqz/ucx_tevib
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_strqz.ucx_tevib', metastore_id=None, name='ucx_tevib', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_strqz/ucx_tevib', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_strqz.ucx_tl5qn: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_strqz/ucx_tl5qn
10:47 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.ucx_strqz.ucx_tl5qn', metastore_id=None, name='ucx_tl5qn', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_strqz.ucx_tevib', view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_strqz.ucx_taedq: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_strqz/ucx_taedq
10:47 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.ucx_strqz.ucx_taedq', metastore_id=None, name='ucx_taedq', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_strqz.ucx_tl5qn', view_dependencies=None)
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918826969, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cmh91', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cmh91', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918826969, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cmh91.ucx_strqz: https://DATABRICKS_HOST/explore/data/ucx_cmh91/ucx_strqz
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cmh91', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cmh91.ucx_strqz', metastore_id=None, name='ucx_strqz', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cmh91, managed_table=hive_metastore.ucx_strqz.ucx_tevib
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_slrum: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_slrum
10:47 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_slrum', metastore_id=None, name='ucx_slrum', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 WARNING [databricks.labs.ucx.hive_metastore.migration_status] Catalog ucx_cac4w no longer exists. Skipping checking its migration status.
10:47 WARNING [databricks.labs.ucx.hive_metastore.migration_status] Catalog ucx_chr2w no longer exists. Skipping checking its migration status.
10:47 WARNING [databricks.labs.ucx.hive_metastore.migration_status] Catalog ucx_csxgr no longer exists. Skipping checking its migration status.
10:47 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating managed table hive_metastore.ucx_strqz.ucx_tevib to using SQL query: CREATE TABLE IF NOT EXISTS ucx_cmh91.ucx_strqz.ucx_tevib DEEP CLONE hive_metastore.ucx_strqz.ucx_tevib;
10:47 INFO [databricks.labs.ucx.hive_metastore.mapping] The intended target for hive_metastore.ucx_strqz.ucx_tevib, ucx_cmh91.ucx_strqz.ucx_tevib, already exists.
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_spc9j: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_spc9j
10:47 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_spc9j', metastore_id=None, name='ucx_spc9j', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_spc9j.ucx_tq0ba: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_spc9j/ucx_tq0ba
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_spc9j.ucx_tq0ba', metastore_id=None, name='ucx_tq0ba', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_spc9j/ucx_tq0ba', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_spc9j.ucx_tsebm: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_spc9j/ucx_tsebm
10:47 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.ucx_spc9j.ucx_tsebm', metastore_id=None, name='ucx_tsebm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_spc9j.ucx_tq0ba', view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_spc9j.ucx_tinwh: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_spc9j/ucx_tinwh
10:47 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.ucx_spc9j.ucx_tinwh', metastore_id=None, name='ucx_tinwh', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_spc9j.ucx_tsebm', view_dependencies=None)
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918858626, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cscuz', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cscuz', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918858626, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cscuz.ucx_spc9j: https://DATABRICKS_HOST/explore/data/ucx_cscuz/ucx_spc9j
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cscuz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cscuz.ucx_spc9j', metastore_id=None, name='ucx_spc9j', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cscuz, managed_table=hive_metastore.ucx_spc9j.ucx_tq0ba
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sauec: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sauec
10:47 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_sauec', metastore_id=None, name='ucx_sauec', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sauec.ucx_tjjq2: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sauec/ucx_tjjq2
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sauec.ucx_tjjq2', metastore_id=None, name='ucx_tjjq2', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sauec/ucx_tjjq2', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sauec.ucx_tdij6: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sauec/ucx_tdij6
10:47 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.ucx_sauec.ucx_tdij6', metastore_id=None, name='ucx_tdij6', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sauec.ucx_tjjq2', view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sauec.ucx_tnost: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sauec/ucx_tnost
10:47 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.ucx_sauec.ucx_tnost', metastore_id=None, name='ucx_tnost', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sauec.ucx_tdij6', view_dependencies=None)
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918870658, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cufzy', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cufzy', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918870658, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cufzy.ucx_sauec: https://DATABRICKS_HOST/explore/data/ucx_cufzy/ucx_sauec
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cufzy', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cufzy.ucx_sauec', metastore_id=None, name='ucx_sauec', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cufzy, managed_table=hive_metastore.ucx_sauec.ucx_tjjq2
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tjjq2 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tdij6 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tnost in the mapping doesn't show up in assessment
10:48 WARNING [databricks.labs.ucx.hive_metastore.migration_status] Catalog ucx_c1rpj no longer exists. Skipping checking its migration status.
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tjjq2 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tdij6 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tnost in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_svltm: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svltm
10:48 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_svltm', metastore_id=None, name='ucx_svltm', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_svltm.ucx_tgzx2: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svltm/ucx_tgzx2
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_svltm.ucx_tgzx2', metastore_id=None, name='ucx_tgzx2', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_svltm/ucx_tgzx2', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_svltm.ucx_t5rnz: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svltm/ucx_t5rnz
10:48 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.ucx_svltm.ucx_t5rnz', metastore_id=None, name='ucx_t5rnz', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_svltm.ucx_tgzx2', view_dependencies=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_svltm.ucx_tykis: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svltm/ucx_tykis
10:48 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.ucx_svltm.ucx_tykis', metastore_id=None, name='ucx_tykis', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_svltm.ucx_t5rnz', view_dependencies=None)
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918901190, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cdwaq', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cdwaq', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918901190, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cdwaq.ucx_svltm: https://DATABRICKS_HOST/explore/data/ucx_cdwaq/ucx_svltm
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cdwaq', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cdwaq.ucx_svltm', metastore_id=None, name='ucx_svltm', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:48 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cdwaq, managed_table=hive_metastore.ucx_svltm.ucx_tgzx2
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_tgzx2 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_t5rnz in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_tykis in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_tgzx2 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_t5rnz in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_tykis in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sp6wo: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sp6wo
10:48 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_sp6wo', metastore_id=None, name='ucx_sp6wo', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sp6wo.ucx_tjt5x: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sp6wo/ucx_tjt5x
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sp6wo.ucx_tjt5x', metastore_id=None, name='ucx_tjt5x', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sp6wo/ucx_tjt5x', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sp6wo.ucx_t8tgm: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sp6wo/ucx_t8tgm
10:48 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.ucx_sp6wo.ucx_t8tgm', metastore_id=None, name='ucx_t8tgm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sp6wo.ucx_tjt5x', view_dependencies=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sp6wo.ucx_tbb03: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sp6wo/ucx_tbb03
10:48 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.ucx_sp6wo.ucx_tbb03', metastore_id=None, name='ucx_tbb03', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sp6wo.ucx_t8tgm', view_dependencies=None)
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918935535, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c4t9z', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c4t9z', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918935535, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_c4t9z.ucx_sp6wo: https://DATABRICKS_HOST/explore/data/ucx_c4t9z/ucx_sp6wo
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c4t9z', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c4t9z.ucx_sp6wo', metastore_id=None, name='ucx_sp6wo', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:48 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_c4t9z, managed_table=hive_metastore.ucx_sp6wo.ucx_tjt5x
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_tjt5x in the mapping doesn't show up in assessment
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_t8tgm in the mapping doesn't show up in assessment
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_tbb03 in the mapping doesn't show up in assessment
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_tjt5x in the mapping doesn't show up in assessment
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_t8tgm in the mapping doesn't show up in assessment
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_tbb03 in the mapping doesn't show up in assessment
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_strqz: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_strqz
10:47 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_strqz', metastore_id=None, name='ucx_strqz', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_strqz.ucx_tevib: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_strqz/ucx_tevib
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_strqz.ucx_tevib', metastore_id=None, name='ucx_tevib', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_strqz/ucx_tevib', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_strqz.ucx_tl5qn: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_strqz/ucx_tl5qn
10:47 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.ucx_strqz.ucx_tl5qn', metastore_id=None, name='ucx_tl5qn', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_strqz.ucx_tevib', view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_strqz.ucx_taedq: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_strqz/ucx_taedq
10:47 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.ucx_strqz.ucx_taedq', metastore_id=None, name='ucx_taedq', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_strqz.ucx_tl5qn', view_dependencies=None)
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918826969, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cmh91', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cmh91', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918826969, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cmh91.ucx_strqz: https://DATABRICKS_HOST/explore/data/ucx_cmh91/ucx_strqz
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cmh91', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cmh91.ucx_strqz', metastore_id=None, name='ucx_strqz', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cmh91, managed_table=hive_metastore.ucx_strqz.ucx_tevib
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_slrum: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_slrum
10:47 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_slrum', metastore_id=None, name='ucx_slrum', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 WARNING [databricks.labs.ucx.hive_metastore.migration_status] Catalog ucx_cac4w no longer exists. Skipping checking its migration status.
10:47 WARNING [databricks.labs.ucx.hive_metastore.migration_status] Catalog ucx_chr2w no longer exists. Skipping checking its migration status.
10:47 WARNING [databricks.labs.ucx.hive_metastore.migration_status] Catalog ucx_csxgr no longer exists. Skipping checking its migration status.
10:47 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating managed table hive_metastore.ucx_strqz.ucx_tevib to using SQL query: CREATE TABLE IF NOT EXISTS ucx_cmh91.ucx_strqz.ucx_tevib DEEP CLONE hive_metastore.ucx_strqz.ucx_tevib;
10:47 INFO [databricks.labs.ucx.hive_metastore.mapping] The intended target for hive_metastore.ucx_strqz.ucx_tevib, ucx_cmh91.ucx_strqz.ucx_tevib, already exists.
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_spc9j: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_spc9j
10:47 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_spc9j', metastore_id=None, name='ucx_spc9j', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_spc9j.ucx_tq0ba: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_spc9j/ucx_tq0ba
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_spc9j.ucx_tq0ba', metastore_id=None, name='ucx_tq0ba', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_spc9j/ucx_tq0ba', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_spc9j.ucx_tsebm: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_spc9j/ucx_tsebm
10:47 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.ucx_spc9j.ucx_tsebm', metastore_id=None, name='ucx_tsebm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_spc9j.ucx_tq0ba', view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_spc9j.ucx_tinwh: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_spc9j/ucx_tinwh
10:47 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.ucx_spc9j.ucx_tinwh', metastore_id=None, name='ucx_tinwh', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_spc9j.ucx_tsebm', view_dependencies=None)
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918858626, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cscuz', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cscuz', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918858626, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cscuz.ucx_spc9j: https://DATABRICKS_HOST/explore/data/ucx_cscuz/ucx_spc9j
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cscuz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cscuz.ucx_spc9j', metastore_id=None, name='ucx_spc9j', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cscuz, managed_table=hive_metastore.ucx_spc9j.ucx_tq0ba
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sauec: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sauec
10:47 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_sauec', metastore_id=None, name='ucx_sauec', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sauec.ucx_tjjq2: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sauec/ucx_tjjq2
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sauec.ucx_tjjq2', metastore_id=None, name='ucx_tjjq2', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sauec/ucx_tjjq2', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sauec.ucx_tdij6: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sauec/ucx_tdij6
10:47 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.ucx_sauec.ucx_tdij6', metastore_id=None, name='ucx_tdij6', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sauec.ucx_tjjq2', view_dependencies=None)
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sauec.ucx_tnost: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sauec/ucx_tnost
10:47 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.ucx_sauec.ucx_tnost', metastore_id=None, name='ucx_tnost', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sauec.ucx_tdij6', view_dependencies=None)
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918870658, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cufzy', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cufzy', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918870658, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:47 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cufzy.ucx_sauec: https://DATABRICKS_HOST/explore/data/ucx_cufzy/ucx_sauec
10:47 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cufzy', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cufzy.ucx_sauec', metastore_id=None, name='ucx_sauec', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:47 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cufzy, managed_table=hive_metastore.ucx_sauec.ucx_tjjq2
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tjjq2 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tdij6 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tnost in the mapping doesn't show up in assessment
10:48 WARNING [databricks.labs.ucx.hive_metastore.migration_status] Catalog ucx_c1rpj no longer exists. Skipping checking its migration status.
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tjjq2 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tdij6 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sauec.ucx_tnost in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_svltm: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svltm
10:48 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_svltm', metastore_id=None, name='ucx_svltm', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_svltm.ucx_tgzx2: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svltm/ucx_tgzx2
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_svltm.ucx_tgzx2', metastore_id=None, name='ucx_tgzx2', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_svltm/ucx_tgzx2', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_svltm.ucx_t5rnz: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svltm/ucx_t5rnz
10:48 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.ucx_svltm.ucx_t5rnz', metastore_id=None, name='ucx_t5rnz', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_svltm.ucx_tgzx2', view_dependencies=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_svltm.ucx_tykis: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_svltm/ucx_tykis
10:48 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.ucx_svltm.ucx_tykis', metastore_id=None, name='ucx_tykis', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_svltm.ucx_t5rnz', view_dependencies=None)
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918901190, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cdwaq', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cdwaq', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918901190, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cdwaq.ucx_svltm: https://DATABRICKS_HOST/explore/data/ucx_cdwaq/ucx_svltm
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cdwaq', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cdwaq.ucx_svltm', metastore_id=None, name='ucx_svltm', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:48 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cdwaq, managed_table=hive_metastore.ucx_svltm.ucx_tgzx2
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_tgzx2 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_t5rnz in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_tykis in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_tgzx2 in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_t5rnz in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_svltm.ucx_tykis in the mapping doesn't show up in assessment
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sp6wo: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sp6wo
10:48 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_sp6wo', metastore_id=None, name='ucx_sp6wo', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sp6wo.ucx_tjt5x: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sp6wo/ucx_tjt5x
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sp6wo.ucx_tjt5x', metastore_id=None, name='ucx_tjt5x', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sp6wo/ucx_tjt5x', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sp6wo.ucx_t8tgm: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sp6wo/ucx_t8tgm
10:48 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.ucx_sp6wo.ucx_t8tgm', metastore_id=None, name='ucx_t8tgm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sp6wo.ucx_tjt5x', view_dependencies=None)
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sp6wo.ucx_tbb03: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sp6wo/ucx_tbb03
10:48 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.ucx_sp6wo.ucx_tbb03', metastore_id=None, name='ucx_tbb03', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sp6wo.ucx_t8tgm', view_dependencies=None)
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918935535, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c4t9z', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c4t9z', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918935535, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:48 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_c4t9z.ucx_sp6wo: https://DATABRICKS_HOST/explore/data/ucx_c4t9z/ucx_sp6wo
10:48 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c4t9z', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c4t9z.ucx_sp6wo', metastore_id=None, name='ucx_sp6wo', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:48 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_c4t9z, managed_table=hive_metastore.ucx_sp6wo.ucx_tjt5x
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_tjt5x in the mapping doesn't show up in assessment
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_t8tgm in the mapping doesn't show up in assessment
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_tbb03 in the mapping doesn't show up in assessment
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_tjt5x in the mapping doesn't show up in assessment
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_t8tgm in the mapping doesn't show up in assessment
10:49 INFO [databricks.labs.ucx.hive_metastore.mapping] Table hive_metastore.ucx_sp6wo.ucx_tbb03 in the mapping doesn't show up in assessment
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 5 catalog fixtures
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918826969, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cmh91', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cmh91', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918826969, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918858626, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cscuz', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cscuz', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918858626, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918870658, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cufzy', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cufzy', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918870658, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918901190, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cdwaq', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cdwaq', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918901190, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918935535, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c4t9z', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c4t9z', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918935535, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 15 table fixtures
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_strqz.ucx_tevib', metastore_id=None, name='ucx_tevib', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_strqz/ucx_tevib', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 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.ucx_strqz.ucx_tl5qn', metastore_id=None, name='ucx_tl5qn', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_strqz.ucx_tevib', view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.ucx_strqz.ucx_tl5qn', metastore_id=None, name='ucx_tl5qn', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_strqz.ucx_tevib', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.ucx_strqz.ucx_tl5qn is a VIEW. Use DROP VIEW instead.
10:49 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.ucx_strqz.ucx_taedq', metastore_id=None, name='ucx_taedq', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_strqz.ucx_tl5qn', view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.ucx_strqz.ucx_taedq', metastore_id=None, name='ucx_taedq', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_strqz', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_strqz.ucx_tl5qn', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.ucx_strqz.ucx_taedq is a VIEW. Use DROP VIEW instead.
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_spc9j.ucx_tq0ba', metastore_id=None, name='ucx_tq0ba', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_spc9j/ucx_tq0ba', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 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.ucx_spc9j.ucx_tsebm', metastore_id=None, name='ucx_tsebm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_spc9j.ucx_tq0ba', view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.ucx_spc9j.ucx_tsebm', metastore_id=None, name='ucx_tsebm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_spc9j.ucx_tq0ba', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.ucx_spc9j.ucx_tsebm is a VIEW. Use DROP VIEW instead.
10:49 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.ucx_spc9j.ucx_tinwh', metastore_id=None, name='ucx_tinwh', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_spc9j.ucx_tsebm', view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.ucx_spc9j.ucx_tinwh', metastore_id=None, name='ucx_tinwh', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_spc9j', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_spc9j.ucx_tsebm', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.ucx_spc9j.ucx_tinwh is a VIEW. Use DROP VIEW instead.
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sauec.ucx_tjjq2', metastore_id=None, name='ucx_tjjq2', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sauec/ucx_tjjq2', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 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.ucx_sauec.ucx_tdij6', metastore_id=None, name='ucx_tdij6', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sauec.ucx_tjjq2', view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.ucx_sauec.ucx_tdij6', metastore_id=None, name='ucx_tdij6', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sauec.ucx_tjjq2', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.ucx_sauec.ucx_tdij6 is a VIEW. Use DROP VIEW instead.
10:49 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.ucx_sauec.ucx_tnost', metastore_id=None, name='ucx_tnost', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sauec.ucx_tdij6', view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.ucx_sauec.ucx_tnost', metastore_id=None, name='ucx_tnost', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sauec', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sauec.ucx_tdij6', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.ucx_sauec.ucx_tnost is a VIEW. Use DROP VIEW instead.
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_svltm.ucx_tgzx2', metastore_id=None, name='ucx_tgzx2', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_svltm/ucx_tgzx2', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 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.ucx_svltm.ucx_t5rnz', metastore_id=None, name='ucx_t5rnz', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_svltm.ucx_tgzx2', view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.ucx_svltm.ucx_t5rnz', metastore_id=None, name='ucx_t5rnz', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_svltm.ucx_tgzx2', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.ucx_svltm.ucx_t5rnz is a VIEW. Use DROP VIEW instead.
10:49 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.ucx_svltm.ucx_tykis', metastore_id=None, name='ucx_tykis', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_svltm.ucx_t5rnz', view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.ucx_svltm.ucx_tykis', metastore_id=None, name='ucx_tykis', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_svltm', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_svltm.ucx_t5rnz', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.ucx_svltm.ucx_tykis is a VIEW. Use DROP VIEW instead.
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sp6wo.ucx_tjt5x', metastore_id=None, name='ucx_tjt5x', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sp6wo/ucx_tjt5x', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 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.ucx_sp6wo.ucx_t8tgm', metastore_id=None, name='ucx_t8tgm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sp6wo.ucx_tjt5x', view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.ucx_sp6wo.ucx_t8tgm', metastore_id=None, name='ucx_t8tgm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sp6wo.ucx_tjt5x', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.ucx_sp6wo.ucx_t8tgm is a VIEW. Use DROP VIEW instead.
10:49 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.ucx_sp6wo.ucx_tbb03', metastore_id=None, name='ucx_tbb03', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sp6wo.ucx_t8tgm', view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] ignoring error while table 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.ucx_sp6wo.ucx_tbb03', metastore_id=None, name='ucx_tbb03', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sp6wo', sql_path=None, storage_credential_name=None, storage_location=None, table_constraints=None, table_id=None, table_type=<TableType.VIEW: 'VIEW'>, updated_at=None, updated_by=None, view_definition='SELECT * FROM hive_metastore.ucx_sp6wo.ucx_t8tgm', view_dependencies=None) teardown: [WRONG_COMMAND_FOR_OBJECT_TYPE] The operation DROP TABLE requires a EXTERNAL or MANAGED. But hive_metastore.ucx_sp6wo.ucx_tbb03 is a VIEW. Use DROP VIEW instead.
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 11 schema fixtures
10:49 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_strqz', metastore_id=None, name='ucx_strqz', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cmh91', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cmh91.ucx_strqz', metastore_id=None, name='ucx_strqz', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 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_slrum', metastore_id=None, name='ucx_slrum', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 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_spc9j', metastore_id=None, name='ucx_spc9j', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cscuz', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cscuz.ucx_spc9j', metastore_id=None, name='ucx_spc9j', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 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_sauec', metastore_id=None, name='ucx_sauec', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cufzy', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cufzy.ucx_sauec', metastore_id=None, name='ucx_sauec', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 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_svltm', metastore_id=None, name='ucx_svltm', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cdwaq', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cdwaq.ucx_svltm', metastore_id=None, name='ucx_svltm', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 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_sp6wo', metastore_id=None, name='ucx_sp6wo', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c4t9z', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c4t9z.ucx_sp6wo', metastore_id=None, name='ucx_sp6wo', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw6] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python

❌ test_revert_migrated_table: AssertionError: assert not True (34.242s)

AssertionError: assert not True
 +  where True = <bound method TablesMigrator.is_migrated of <databricks.labs.ucx.hive_metastore.table_migrate.TablesMigrator object at 0x7fce52a8ed40>>('ucx_sy3oe', 'ucx_tzpjy')
 +    where <bound method TablesMigrator.is_migrated of <databricks.labs.ucx.hive_metastore.table_migrate.TablesMigrator object at 0x7fce52a8ed40>> = <databricks.labs.ucx.hive_metastore.table_migrate.TablesMigrator object at 0x7fce52a8ed40>.is_migrated
 +      where <databricks.labs.ucx.hive_metastore.table_migrate.TablesMigrator object at 0x7fce52a8ed40> = <tests.integration.conftest.TestRuntimeContext object at 0x7fce52a8c3d0>.tables_migrator
 +    and   'ucx_sy3oe' = TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=N...le_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None).schema_name
 +    and   'ucx_tzpjy' = TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=N...le_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None).name
[gw6] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sy3oe: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sy3oe
10:49 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_sy3oe', metastore_id=None, name='ucx_sy3oe', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_swbyn: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_swbyn
10:49 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_swbyn', metastore_id=None, name='ucx_swbyn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sy3oe.ucx_tzpjy: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sy3oe/ucx_tzpjy
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sy3oe.ucx_tzpjy', metastore_id=None, name='ucx_tzpjy', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sy3oe', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sy3oe/ucx_tzpjy', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sy3oe.ucx_tw0sm: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sy3oe/ucx_tw0sm
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sy3oe.ucx_tw0sm', metastore_id=None, name='ucx_tw0sm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sy3oe', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sy3oe/ucx_tw0sm', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_swbyn.ucx_tguhg: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_swbyn/ucx_tguhg
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_swbyn.ucx_tguhg', metastore_id=None, name='ucx_tguhg', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_swbyn', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_swbyn/ucx_tguhg', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918990333, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwss6', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cwss6', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918990333, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cwss6.ucx_sy3oe: https://DATABRICKS_HOST/explore/data/ucx_cwss6/ucx_sy3oe
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cwss6', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwss6.ucx_sy3oe', metastore_id=None, name='ucx_sy3oe', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cwss6.ucx_swbyn: https://DATABRICKS_HOST/explore/data/ucx_cwss6/ucx_swbyn
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cwss6', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwss6.ucx_swbyn', metastore_id=None, name='ucx_swbyn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_srqw6: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_srqw6
10:49 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_srqw6', metastore_id=None, name='ucx_srqw6', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating managed table hive_metastore.ucx_sy3oe.ucx_tzpjy to using SQL query: CREATE TABLE IF NOT EXISTS ucx_cwss6.ucx_sy3oe.ucx_tzpjy DEEP CLONE hive_metastore.ucx_sy3oe.ucx_tzpjy;
10:49 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating managed table hive_metastore.ucx_swbyn.ucx_tguhg to using SQL query: CREATE TABLE IF NOT EXISTS ucx_cwss6.ucx_swbyn.ucx_tguhg DEEP CLONE hive_metastore.ucx_swbyn.ucx_tguhg;
10:50 INFO [databricks.labs.ucx.hive_metastore.table_migrate] Reverting MANAGED table ucx_sy3oe.ucx_tzpjy upgraded_to None
10:50 INFO [databricks.labs.ucx.hive_metastore.migration_status] ucx_sy3oe.ucx_tzpjy is set as migrated
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sy3oe: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sy3oe
10:49 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_sy3oe', metastore_id=None, name='ucx_sy3oe', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_swbyn: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_swbyn
10:49 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_swbyn', metastore_id=None, name='ucx_swbyn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sy3oe.ucx_tzpjy: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sy3oe/ucx_tzpjy
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sy3oe.ucx_tzpjy', metastore_id=None, name='ucx_tzpjy', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sy3oe', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sy3oe/ucx_tzpjy', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sy3oe.ucx_tw0sm: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sy3oe/ucx_tw0sm
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sy3oe.ucx_tw0sm', metastore_id=None, name='ucx_tw0sm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sy3oe', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sy3oe/ucx_tw0sm', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_swbyn.ucx_tguhg: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_swbyn/ucx_tguhg
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_swbyn.ucx_tguhg', metastore_id=None, name='ucx_tguhg', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_swbyn', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_swbyn/ucx_tguhg', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918990333, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwss6', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cwss6', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918990333, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cwss6.ucx_sy3oe: https://DATABRICKS_HOST/explore/data/ucx_cwss6/ucx_sy3oe
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cwss6', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwss6.ucx_sy3oe', metastore_id=None, name='ucx_sy3oe', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cwss6.ucx_swbyn: https://DATABRICKS_HOST/explore/data/ucx_cwss6/ucx_swbyn
10:49 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cwss6', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwss6.ucx_swbyn', metastore_id=None, name='ucx_swbyn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_srqw6: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_srqw6
10:49 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_srqw6', metastore_id=None, name='ucx_srqw6', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:49 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating managed table hive_metastore.ucx_sy3oe.ucx_tzpjy to using SQL query: CREATE TABLE IF NOT EXISTS ucx_cwss6.ucx_sy3oe.ucx_tzpjy DEEP CLONE hive_metastore.ucx_sy3oe.ucx_tzpjy;
10:49 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating managed table hive_metastore.ucx_swbyn.ucx_tguhg to using SQL query: CREATE TABLE IF NOT EXISTS ucx_cwss6.ucx_swbyn.ucx_tguhg DEEP CLONE hive_metastore.ucx_swbyn.ucx_tguhg;
10:50 INFO [databricks.labs.ucx.hive_metastore.table_migrate] Reverting MANAGED table ucx_sy3oe.ucx_tzpjy upgraded_to None
10:50 INFO [databricks.labs.ucx.hive_metastore.migration_status] ucx_sy3oe.ucx_tzpjy is set as migrated
10:50 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures
10:50 DEBUG [databricks.labs.ucx.mixins.fixtures] removing catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1712918990333, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwss6', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cwss6', options=None, owner='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', properties=None, provider_name=None, provisioning_info=None, securable_kind=<CatalogInfoSecurableKind.CATALOG_STANDARD: 'CATALOG_STANDARD'>, securable_type='CATALOG', share_name=None, storage_location=None, storage_root=None, updated_at=1712918990333, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
10:50 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 0 table fixtures
10:50 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 table fixtures
10:50 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sy3oe.ucx_tzpjy', metastore_id=None, name='ucx_tzpjy', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sy3oe', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sy3oe/ucx_tzpjy', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:50 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sy3oe.ucx_tw0sm', metastore_id=None, name='ucx_tw0sm', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sy3oe', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sy3oe/ucx_tw0sm', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:50 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_swbyn.ucx_tguhg', metastore_id=None, name='ucx_tguhg', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_swbyn', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_swbyn/ucx_tguhg', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
10:50 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 5 schema fixtures
10:50 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_sy3oe', metastore_id=None, name='ucx_sy3oe', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:50 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_swbyn', metastore_id=None, name='ucx_swbyn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:50 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cwss6', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwss6.ucx_sy3oe', metastore_id=None, name='ucx_sy3oe', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:50 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cwss6', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cwss6.ucx_swbyn', metastore_id=None, name='ucx_swbyn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
10:50 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_srqw6', metastore_id=None, name='ucx_srqw6', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw6] linux -- Python 3.10.14 /home/runner/work/ucx/ucx/.venv/bin/python

Flaky tests:

🤪 test_running_real_assessment_job (6m28.134s)
🤪 test_running_real_migrate_groups_job (4m35.407s)

_{Running from acceptance #2250}

nfx

lgtm

nkvuong requested review from a team and aminmovahed-db April 12, 2024 09:36

nkvuong had a problem deploying to account-admin April 12, 2024 09:36 — with GitHub Actions Failure

temporarily disable tests that do not work on aws

3700fbd

nkvuong force-pushed the fix/integration_test_aws branch from 47e9316 to 3700fbd Compare April 12, 2024 10:45

nkvuong had a problem deploying to account-admin April 12, 2024 10:45 — with GitHub Actions Failure

nfx approved these changes Apr 12, 2024

View reviewed changes

nfx merged commit 8ef9e25 into main Apr 12, 2024

nfx deleted the fix/integration_test_aws branch April 12, 2024 14:52

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Temporarily disabled tests that do not work on aws#1377

Temporarily disabled tests that do not work on aws#1377
nfx merged 1 commit intomainfrom
fix/integration_test_aws

nkvuong commented Apr 12, 2024

Uh oh!

github-actions bot commented Apr 12, 2024 •

edited

Loading

Uh oh!

nfx left a comment

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

Conversation

nkvuong commented Apr 12, 2024

Changes

Tests

Uh oh!

github-actions bot commented Apr 12, 2024 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

nfx left a comment

Choose a reason for hiding this comment

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

github-actions bot commented Apr 12, 2024 •

edited

Loading