Skip to content
New issue

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

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

Already on GitHub? Sign in to your account

Added more cross-linking between CLI commands #1091

Merged
merged 1 commit into from
Mar 22, 2024
Merged

Added more cross-linking between CLI commands #1091

merged 1 commit into from
Mar 22, 2024

Conversation

nfx
Copy link
Collaborator

@nfx nfx commented Mar 22, 2024

No description provided.

@nfx nfx requested review from a team and dmoore247 March 22, 2024 20:33
@nfx nfx merged commit 4b5d31b into main Mar 22, 2024
4 of 6 checks passed
@nfx nfx deleted the moar/docz branch March 22, 2024 20:34
Copy link

❌ 111/113 passed, 1 flaky, 2 failed, 20 skipped, 1h30m25s total

❌ test_migrate_external_table: databricks.labs.blueprint.parallel.ManyError: Detected 1 failures: BadRequest: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration. (35.786s)
databricks.labs.blueprint.parallel.ManyError: Detected 1 failures: BadRequest: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sjkan: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sjkan
20:35 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_sjkan', metastore_id=None, name='ucx_sjkan', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw6] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sjkan: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sjkan
20:35 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_sjkan', metastore_id=None, name='ucx_sjkan', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_szzgf: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_szzgf
20:35 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_szzgf', metastore_id=None, name='ucx_szzgf', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/rJUI
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_szzgf.ucx_tcbar: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_szzgf/ucx_tcbar
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_szzgf.ucx_tcbar', metastore_id=None, name='ucx_tcbar', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_szzgf', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/rJUI', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:35 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=1711139739804, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6qhb', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c6qhb', 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=1711139739804, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_c6qhb.ucx_szzgf: https://DATABRICKS_HOST/explore/data/ucx_c6qhb/ucx_szzgf
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c6qhb', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6qhb.ucx_szzgf', metastore_id=None, name='ucx_szzgf', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:35 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_c6qhb, external_table=hive_metastore.ucx_szzgf.ucx_tcbar
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_scrn7: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_scrn7
20:35 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_scrn7', metastore_id=None, name='ucx_scrn7', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/fVtb
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_scrn7.ucx_ts8op: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_scrn7/ucx_ts8op
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_scrn7.ucx_ts8op', metastore_id=None, name='ucx_ts8op', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_scrn7', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/fVtb', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:35 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=1711139750570, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cx3qn', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cx3qn', 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=1711139750570, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cx3qn.ucx_scrn7: https://DATABRICKS_HOST/explore/data/ucx_cx3qn/ucx_scrn7
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cx3qn', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cx3qn.ucx_scrn7', metastore_id=None, name='ucx_scrn7', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:35 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cx3qn, external_table=hive_metastore.ucx_scrn7.ucx_ts8op
20:35 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating external table hive_metastore.ucx_scrn7.ucx_ts8op to using SQL query: SYNC TABLE ucx_cx3qn.ucx_scrn7.ucx_ts8op FROM hive_metastore.ucx_scrn7.ucx_ts8op;
20:36 ERROR [databricks.labs.blueprint.parallel] migrate tables task failed: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
Traceback (most recent call last):
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/blueprint/parallel.py", line 135, in inner
    return func(*args, **kwargs), None
  File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/table_migrate.py", line 111, in _migrate_table
    return self._migrate_external_table(src_table, rule, grants)
  File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/table_migrate.py", line 128, in _migrate_external_table
    self._backend.execute(src_table.sql_alter_from(rule.as_uc_table_key, self._ws.get_workspace_id()))
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/backends.py", line 142, in execute
    self._sql.execute(sql)
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 238, in execute
    self._raise_if_needed(status)
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 473, in _raise_if_needed
    raise error_class(error_message)
databricks.sdk.errors.platform.BadRequest: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
20:36 CRITICAL [databricks.labs.blueprint.parallel] All 'migrate tables' tasks failed!!!
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sjkan: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sjkan
20:35 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_sjkan', metastore_id=None, name='ucx_sjkan', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_szzgf: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_szzgf
20:35 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_szzgf', metastore_id=None, name='ucx_szzgf', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/rJUI
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_szzgf.ucx_tcbar: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_szzgf/ucx_tcbar
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_szzgf.ucx_tcbar', metastore_id=None, name='ucx_tcbar', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_szzgf', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/rJUI', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:35 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=1711139739804, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6qhb', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c6qhb', 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=1711139739804, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_c6qhb.ucx_szzgf: https://DATABRICKS_HOST/explore/data/ucx_c6qhb/ucx_szzgf
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c6qhb', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6qhb.ucx_szzgf', metastore_id=None, name='ucx_szzgf', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:35 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_c6qhb, external_table=hive_metastore.ucx_szzgf.ucx_tcbar
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_scrn7: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_scrn7
20:35 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_scrn7', metastore_id=None, name='ucx_scrn7', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/fVtb
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_scrn7.ucx_ts8op: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_scrn7/ucx_ts8op
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_scrn7.ucx_ts8op', metastore_id=None, name='ucx_ts8op', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_scrn7', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/fVtb', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:35 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=1711139750570, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cx3qn', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cx3qn', 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=1711139750570, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
20:35 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cx3qn.ucx_scrn7: https://DATABRICKS_HOST/explore/data/ucx_cx3qn/ucx_scrn7
20:35 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cx3qn', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cx3qn.ucx_scrn7', metastore_id=None, name='ucx_scrn7', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:35 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cx3qn, external_table=hive_metastore.ucx_scrn7.ucx_ts8op
20:35 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating external table hive_metastore.ucx_scrn7.ucx_ts8op to using SQL query: SYNC TABLE ucx_cx3qn.ucx_scrn7.ucx_ts8op FROM hive_metastore.ucx_scrn7.ucx_ts8op;
20:36 ERROR [databricks.labs.blueprint.parallel] migrate tables task failed: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
Traceback (most recent call last):
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/blueprint/parallel.py", line 135, in inner
    return func(*args, **kwargs), None
  File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/table_migrate.py", line 111, in _migrate_table
    return self._migrate_external_table(src_table, rule, grants)
  File "/home/runner/work/ucx/ucx/src/databricks/labs/ucx/hive_metastore/table_migrate.py", line 128, in _migrate_external_table
    self._backend.execute(src_table.sql_alter_from(rule.as_uc_table_key, self._ws.get_workspace_id()))
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/backends.py", line 142, in execute
    self._sql.execute(sql)
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 238, in execute
    self._raise_if_needed(status)
  File "/home/runner/work/ucx/ucx/.venv/lib/python3.10/site-packages/databricks/labs/lsql/core.py", line 473, in _raise_if_needed
    raise error_class(error_message)
databricks.sdk.errors.platform.BadRequest: PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
20:36 CRITICAL [databricks.labs.blueprint.parallel] All 'migrate tables' tasks failed!!!
20:36 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 make_dbfs_data_copy fixtures
20:36 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/rJUI
20:36 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/fVtb
20:36 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 table fixtures
20:36 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_szzgf.ucx_tcbar', metastore_id=None, name='ucx_tcbar', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_szzgf', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/rJUI', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:36 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_scrn7.ucx_ts8op', metastore_id=None, name='ucx_ts8op', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_scrn7', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/fVtb', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:36 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 catalog fixtures
20:36 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=1711139739804, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6qhb', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_c6qhb', 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=1711139739804, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
20:36 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=1711139750570, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cx3qn', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cx3qn', 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=1711139750570, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
20:36 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 5 schema fixtures
20:36 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_sjkan', metastore_id=None, name='ucx_sjkan', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:36 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_szzgf', metastore_id=None, name='ucx_szzgf', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:36 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_c6qhb', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_c6qhb.ucx_szzgf', metastore_id=None, name='ucx_szzgf', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:36 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_scrn7', metastore_id=None, name='ucx_scrn7', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:36 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cx3qn', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cx3qn.ucx_scrn7', metastore_id=None, name='ucx_scrn7', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw6] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
❌ test_table_migration_job_cluster_override: databricks.sdk.errors.platform.Unknown: (java.lang.SecurityException) PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration. (8m23.949s)
databricks.sdk.errors.platform.Unknown: (java.lang.SecurityException) PERMISSION_DENIED: Failed to get credentials: Storage Credential TEST_STORAGE_CREDENTIAL is not configured correctly. Please contact the owner or your account admin to update the configuration.
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sbvy1: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sbvy1
20:38 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_sbvy1', metastore_id=None, name='ucx_sbvy1', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw1] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sbvy1: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sbvy1
20:38 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_sbvy1', metastore_id=None, name='ucx_sbvy1', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sgbmj: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sgbmj
20:38 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_sgbmj', metastore_id=None, name='ucx_sgbmj', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sgbmj.ucx_tiuco: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sgbmj/ucx_tiuco
20:38 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_sgbmj.ucx_tiuco', metastore_id=None, name='ucx_tiuco', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sgbmj', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sgbmj/ucx_tiuco', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:38 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/cto2
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sgbmj.ucx_tvr8u: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sgbmj/ucx_tvr8u
20:38 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sgbmj.ucx_tvr8u', metastore_id=None, name='ucx_tvr8u', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sgbmj', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/cto2', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:38 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=1711139912699, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_csu8u', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_csu8u', 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=1711139912699, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_csu8u.ucx_sgbmj: https://DATABRICKS_HOST/explore/data/ucx_csu8u/ucx_sgbmj
20:38 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_csu8u', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_csu8u.ucx_sgbmj', metastore_id=None, name='ucx_sgbmj', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:38 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.ucx/config.yml) doesn't exist.
20:38 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
20:38 INFO [databricks.labs.ucx.installer.hms_lineage] HMS Lineage feature creates one system table named system.hms_to_uc_migration.table_access and helps in your migration process from HMS to UC by allowing you to programmatically query HMS lineage data.
20:38 INFO [databricks.labs.ucx.install] Fetching installations...
20:38 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
20:38 INFO [databricks.labs.ucx.install] Installing UCX v0.18.1+520240322203839
20:38 INFO [databricks.labs.ucx.install] Creating dashboards...
20:38 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
20:38 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Estimates)...
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 01_0_group_migration.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 01_0_group_migration.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_metastore_assignment.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_metastore_assignment.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_data_modeling.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_data_modeling.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 03_0_data_migration.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 03_0_data_migration.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
20:38 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Main)...
20:39 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
20:39 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Azure)...
20:39 DEBUG [databricks.labs.ucx.installer.workflows] Creating jobs from tasks in main
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=099-destroy-schema
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
20:39 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
20:39 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
20:39 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.ucx/README for the next steps.
20:39 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-tables job: https://DATABRICKS_HOST#job/116490694161875
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sbvy1: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sbvy1
20:38 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_sbvy1', metastore_id=None, name='ucx_sbvy1', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sgbmj: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sgbmj
20:38 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_sgbmj', metastore_id=None, name='ucx_sgbmj', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sgbmj.ucx_tiuco: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sgbmj/ucx_tiuco
20:38 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_sgbmj.ucx_tiuco', metastore_id=None, name='ucx_tiuco', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sgbmj', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sgbmj/ucx_tiuco', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:38 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/cto2
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sgbmj.ucx_tvr8u: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sgbmj/ucx_tvr8u
20:38 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sgbmj.ucx_tvr8u', metastore_id=None, name='ucx_tvr8u', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sgbmj', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/cto2', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:38 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=1711139912699, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_csu8u', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_csu8u', 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=1711139912699, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
20:38 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_csu8u.ucx_sgbmj: https://DATABRICKS_HOST/explore/data/ucx_csu8u/ucx_sgbmj
20:38 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_csu8u', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_csu8u.ucx_sgbmj', metastore_id=None, name='ucx_sgbmj', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:38 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.ucx/config.yml) doesn't exist.
20:38 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
20:38 INFO [databricks.labs.ucx.installer.hms_lineage] HMS Lineage feature creates one system table named system.hms_to_uc_migration.table_access and helps in your migration process from HMS to UC by allowing you to programmatically query HMS lineage data.
20:38 INFO [databricks.labs.ucx.install] Fetching installations...
20:38 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
20:38 INFO [databricks.labs.ucx.install] Installing UCX v0.18.1+520240322203839
20:38 INFO [databricks.labs.ucx.install] Creating dashboards...
20:38 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
20:38 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Estimates)...
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 01_0_group_migration.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 01_0_group_migration.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_metastore_assignment.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_metastore_assignment.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_data_modeling.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_data_modeling.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 03_0_data_migration.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 03_0_data_migration.md because it's a text widget
20:38 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
20:38 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Main)...
20:39 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
20:39 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Azure)...
20:39 DEBUG [databricks.labs.ucx.installer.workflows] Creating jobs from tasks in main
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=099-destroy-schema
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
20:39 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
20:39 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
20:39 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
20:39 INFO [databricks.labs.ucx.install] Installation completed successfully! Please refer to the https://DATABRICKS_HOST/#workspace/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.ucx/README for the next steps.
20:39 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-tables job: https://DATABRICKS_HOST#job/116490694161875
20:46 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures
20:46 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/cto2
20:46 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 table fixtures
20:46 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_sgbmj.ucx_tiuco', metastore_id=None, name='ucx_tiuco', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sgbmj', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sgbmj/ucx_tiuco', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:46 DEBUG [databricks.labs.ucx.mixins.fixtures] removing table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sgbmj.ucx_tvr8u', metastore_id=None, name='ucx_tvr8u', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sgbmj', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/cto2', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
20:46 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures
20:46 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=1711139912699, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_csu8u', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_csu8u', 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=1711139912699, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
20:46 INFO [databricks.labs.ucx.install] Deleting UCX v0.18.1+520240322204640 from https://DATABRICKS_HOST
20:46 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_sbvy1
20:46 INFO [databricks.labs.ucx.install] Deleting jobs
20:46 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=201543961696962.
20:46 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=897850860902783.
20:46 INFO [databricks.labs.ucx.install] Deleting 099-destroy-schema job_id=279143902020262.
20:46 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=27943125546828.
20:46 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=116490694161875.
20:46 INFO [databricks.labs.ucx.install] Deleting assessment job_id=1099406192666966.
20:46 INFO [databricks.labs.ucx.install] Deleting cluster policy
20:46 INFO [databricks.labs.ucx.install] Deleting secret scope
20:46 INFO [databricks.labs.ucx.install] UnInstalling UCX complete
20:46 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures
20:46 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_sbvy1', metastore_id=None, name='ucx_sbvy1', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:46 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_sgbmj', metastore_id=None, name='ucx_sgbmj', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
20:46 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_csu8u', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_csu8u.ucx_sgbmj', metastore_id=None, name='ucx_sgbmj', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw1] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python

Flaky tests:

  • 🤪 test_migrate_external_table_failed_sync (7.018s)

Running from acceptance #1713

nfx added a commit that referenced this pull request Mar 25, 2024
* Added instance pool id to WorkspaceConfig ([#1087](#1087)). In this release, the `create` method of the `_policy_installer` object has been updated to return an additional value, `instance_pool_id`, which is then assigned and passed as an argument to the `WorkspaceConfig` object in the `_configure_new_installation` method. The `ClusterPolicyInstaller` class in the `v0.15.0_added_cluster_policy.py` file has also been updated to return a fourth value, `instance_pool_id`, from the `create` method, allowing for more flexibility in future enhancements. Additionally, the test function `test_table_migration_job` in the `test_installation.py` file has been updated to skip when the script is not being run as part of a nightly test job or in debug mode, and the test functions in the `test_policy.py` file have been updated to reflect the new return value in the `create` method. These changes enable better management and scaling of resources through instance pools, provide more granular control in the WorkspaceConfig, and improve testing efficiency.
* Added more cross-linking between CLI commands ([#1091](#1091)). In this release, we have introduced several enhancements to our open-source library's Command Line Interface (CLI) and documentation. Specifically, we have added more cross-linking between CLI commands to improve navigation and usability. The documentation has been updated to include a new step in the UCX installation process, where users are required to run the assessment workflow after installing UCX. This workflow is the first step in the migration process and checks the compatibility of the user's workspace with Unity Catalog. Additionally, we have added new commands for principal-prefix-access, migrate-credentials, and migrate-locations, which are part of the table migration process. These new commands require the assessment workflow and group migration workflow to be completed before they can be executed. Overall, these changes aim to provide a more streamlined and detailed installation and migration process, improving the user experience for software engineers.
* Fixed command references in README.md ([#1093](#1093)). In this release, we have made improvements to the command references in the README.md file to enhance the overall readability and usability of the documentation for software engineers. Specifically, we have updated the links for the `migrate-locations` and `validate_external_locations` commands to use the correct syntax, enclosing them in backticks to denote code. This change ensures that the links are correctly interpreted as commands and addresses any issues that may have arisen with their previous formatting. It is important to note that no new methods have been added in this release, and the existing functionality of the commands has not been changed in scope or functionality.
* Fixing the issue in workspace id flag in create-account-group command ([#1094](#1094)). In this update, we have improved the `create_account_group` command related to the `workspace_ids` flag in our open-source library. The `workspace_ids` flag's type has been changed from `list[int] | None` to `str | None`, allowing for easier input of multiple workspace IDs as a string of comma-separated integers. The `create_account_level_groups` function in the `AccountWorkspaces` class has been updated to accept this string and convert it to a list of integers before proceeding. To ensure proper functioning, we added a new test case `test_create_account_groups_with_id()` to check if the command handles the case when no workspace IDs are provided in the configuration. The `create_account_groups()` method now checks for this condition and raises a `ValueError`. Furthermore, the `manual_workspace_info()` method has been updated to handle workspace name input by the user, receiving the `ws` object, along with prompts that contain the user input for the workspace name and the next workspace ID.
* Rely UCX on the latest 14.3 LTS DBR instead of 15.x ([#1097](#1097)). In this release, we have implemented a quick fix to rely on the Long Term Support (LTS) version 14.3 of the Databricks Runtime (DBR) instead of 15.x for UCX, addressing issue [#1096](#1096). This change affects the `_definition` function, which has been modified to use the latest LTS DBR instead of the latest Spark version. The `latest_lts_dbr` variable is now assigned the value returned by the `select_spark_version` method with the `latest=True` and `long_term_support=True` parameters. The `spark_version` key in the `policy_definition` dictionary is set to the value returned by the `_policy_config` method with `latest_lts_dbr` as the argument. Additionally, in the `tests/unit/installer/test_policy.py` file, the `select_spark_version` method of the `clusters` object has been updated to accept any number of arguments and consistently return the string "14.2.x-scala2.12", allowing for greater flexibility. This is a temporary solution, with a more comprehensive fix being tracked in issue [#1098](#1098). Developers should be aware of how the `clusters` object is used in the codebase when adopting this project.
@nfx nfx mentioned this pull request Mar 25, 2024
nfx added a commit that referenced this pull request Mar 25, 2024
* Added instance pool id to WorkspaceConfig
([#1087](#1087)). In this
release, the `create` method of the `_policy_installer` object has been
updated to return an additional value, `instance_pool_id`, which is then
assigned and passed as an argument to the `WorkspaceConfig` object in
the `_configure_new_installation` method. The `ClusterPolicyInstaller`
class in the `v0.15.0_added_cluster_policy.py` file has also been
updated to return a fourth value, `instance_pool_id`, from the `create`
method, allowing for more flexibility in future enhancements.
Additionally, the test function `test_table_migration_job` in the
`test_installation.py` file has been updated to skip when the script is
not being run as part of a nightly test job or in debug mode, and the
test functions in the `test_policy.py` file have been updated to reflect
the new return value in the `create` method. These changes enable better
management and scaling of resources through instance pools, provide more
granular control in the WorkspaceConfig, and improve testing efficiency.
* Added more cross-linking between CLI commands
([#1091](#1091)). In this
release, we have introduced several enhancements to our open-source
library's Command Line Interface (CLI) and documentation. Specifically,
we have added more cross-linking between CLI commands to improve
navigation and usability. The documentation has been updated to include
a new step in the UCX installation process, where users are required to
run the assessment workflow after installing UCX. This workflow is the
first step in the migration process and checks the compatibility of the
user's workspace with Unity Catalog. Additionally, we have added new
commands for principal-prefix-access, migrate-credentials, and
migrate-locations, which are part of the table migration process. These
new commands require the assessment workflow and group migration
workflow to be completed before they can be executed. Overall, these
changes aim to provide a more streamlined and detailed installation and
migration process, improving the user experience for software engineers.
* Fixed command references in README.md
([#1093](#1093)). In this
release, we have made improvements to the command references in the
README.md file to enhance the overall readability and usability of the
documentation for software engineers. Specifically, we have updated the
links for the `migrate-locations` and `validate_external_locations`
commands to use the correct syntax, enclosing them in backticks to
denote code. This change ensures that the links are correctly
interpreted as commands and addresses any issues that may have arisen
with their previous formatting. It is important to note that no new
methods have been added in this release, and the existing functionality
of the commands has not been changed in scope or functionality.
* Fixing the issue in workspace id flag in create-account-group command
([#1094](#1094)). In this
update, we have improved the `create_account_group` command related to
the `workspace_ids` flag in our open-source library. The `workspace_ids`
flag's type has been changed from `list[int] | None` to `str | None`,
allowing for easier input of multiple workspace IDs as a string of
comma-separated integers. The `create_account_level_groups` function in
the `AccountWorkspaces` class has been updated to accept this string and
convert it to a list of integers before proceeding. To ensure proper
functioning, we added a new test case
`test_create_account_groups_with_id()` to check if the command handles
the case when no workspace IDs are provided in the configuration. The
`create_account_groups()` method now checks for this condition and
raises a `ValueError`. Furthermore, the `manual_workspace_info()` method
has been updated to handle workspace name input by the user, receiving
the `ws` object, along with prompts that contain the user input for the
workspace name and the next workspace ID.
* Rely UCX on the latest 14.3 LTS DBR instead of 15.x
([#1097](#1097)). In this
release, we have implemented a quick fix to rely on the Long Term
Support (LTS) version 14.3 of the Databricks Runtime (DBR) instead of
15.x for UCX, addressing issue
[#1096](#1096). This change
affects the `_definition` function, which has been modified to use the
latest LTS DBR instead of the latest Spark version. The `latest_lts_dbr`
variable is now assigned the value returned by the
`select_spark_version` method with the `latest=True` and
`long_term_support=True` parameters. The `spark_version` key in the
`policy_definition` dictionary is set to the value returned by the
`_policy_config` method with `latest_lts_dbr` as the argument.
Additionally, in the `tests/unit/installer/test_policy.py` file, the
`select_spark_version` method of the `clusters` object has been updated
to accept any number of arguments and consistently return the string
"14.2.x-scala2.12", allowing for greater flexibility. This is a
temporary solution, with a more comprehensive fix being tracked in issue
[#1098](#1098). Developers
should be aware of how the `clusters` object is used in the codebase
when adopting this project.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

1 participant