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

Fixing the issue in workspace id flag in create-account-group command #1094

Merged
merged 3 commits into from
Mar 24, 2024

Conversation

prajin-29
Copy link
Contributor

Changes

Workspace Id was taj=king as string instead of list of int. Fixed the same by converting it int list of int using list comprehension.

Linked issues

#1090

Resolves #..

Functionality

  • added relevant user documentation
  • added new CLI command
  • modified existing command: databricks labs ucx ...
  • added a new workflow
  • modified existing workflow: ...
  • added a new table
  • modified existing table: ...

Tests

  • manually tested
  • added unit tests
  • added integration tests
  • verified on staging environment (screenshot attached)

Copy link

codecov bot commented Mar 23, 2024

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 88.81%. Comparing base (fce42a4) to head (65a82df).

Additional details and impacted files
@@           Coverage Diff           @@
##             main    #1094   +/-   ##
=======================================
  Coverage   88.80%   88.81%           
=======================================
  Files          64       64           
  Lines        7130     7133    +3     
  Branches     1282     1284    +2     
=======================================
+ Hits         6332     6335    +3     
  Misses        531      531           
  Partials      267      267           

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

Copy link

❌ 111/113 passed, 1 flaky, 2 failed, 20 skipped, 2h13m21s 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. (28.523s)
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.
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sdcne: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sdcne
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sdcne', metastore_id=None, name='ucx_sdcne', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw8] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sdcne: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sdcne
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sdcne', metastore_id=None, name='ucx_sdcne', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sewdn: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sewdn
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sewdn', metastore_id=None, name='ucx_sewdn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/cm97
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sewdn.ucx_tttj2: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sewdn/ucx_tttj2
18:15 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_sewdn.ucx_tttj2', metastore_id=None, name='ucx_tttj2', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sewdn', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/cm97', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:15 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=1711217731905, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cpoc4', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cpoc4', 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=1711217731905, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cpoc4.ucx_sewdn: https://DATABRICKS_HOST/explore/data/ucx_cpoc4/ucx_sewdn
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cpoc4', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cpoc4.ucx_sewdn', metastore_id=None, name='ucx_sewdn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cpoc4, external_table=hive_metastore.ucx_sewdn.ucx_tttj2
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sm5rw: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sm5rw
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sm5rw', metastore_id=None, name='ucx_sm5rw', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/7Qah
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sm5rw.ucx_tcdb4: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sm5rw/ucx_tcdb4
18:15 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_sm5rw.ucx_tcdb4', metastore_id=None, name='ucx_tcdb4', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sm5rw', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/7Qah', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:15 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=1711217740484, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqb5x', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cqb5x', 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=1711217740484, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cqb5x.ucx_sm5rw: https://DATABRICKS_HOST/explore/data/ucx_cqb5x/ucx_sm5rw
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cqb5x', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqb5x.ucx_sm5rw', metastore_id=None, name='ucx_sm5rw', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cqb5x, external_table=hive_metastore.ucx_sm5rw.ucx_tcdb4
18:15 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating external table hive_metastore.ucx_sm5rw.ucx_tcdb4 to using SQL query: SYNC TABLE ucx_cqb5x.ucx_sm5rw.ucx_tcdb4 FROM hive_metastore.ucx_sm5rw.ucx_tcdb4;
18:15 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.
18:15 CRITICAL [databricks.labs.blueprint.parallel] All 'migrate tables' tasks failed!!!
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sdcne: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sdcne
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sdcne', metastore_id=None, name='ucx_sdcne', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sewdn: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sewdn
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sewdn', metastore_id=None, name='ucx_sewdn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/cm97
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sewdn.ucx_tttj2: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sewdn/ucx_tttj2
18:15 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_sewdn.ucx_tttj2', metastore_id=None, name='ucx_tttj2', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sewdn', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/cm97', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:15 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=1711217731905, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cpoc4', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cpoc4', 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=1711217731905, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cpoc4.ucx_sewdn: https://DATABRICKS_HOST/explore/data/ucx_cpoc4/ucx_sewdn
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cpoc4', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cpoc4.ucx_sewdn', metastore_id=None, name='ucx_sewdn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cpoc4, external_table=hive_metastore.ucx_sewdn.ucx_tttj2
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sm5rw: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sm5rw
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sm5rw', metastore_id=None, name='ucx_sm5rw', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/7Qah
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sm5rw.ucx_tcdb4: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sm5rw/ucx_tcdb4
18:15 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_sm5rw.ucx_tcdb4', metastore_id=None, name='ucx_tcdb4', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sm5rw', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/7Qah', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:15 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=1711217740484, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqb5x', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cqb5x', 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=1711217740484, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
18:15 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_cqb5x.ucx_sm5rw: https://DATABRICKS_HOST/explore/data/ucx_cqb5x/ucx_sm5rw
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cqb5x', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqb5x.ucx_sm5rw', metastore_id=None, name='ucx_sm5rw', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 INFO [tests.integration.hive_metastore.test_migrate] dst_catalog=ucx_cqb5x, external_table=hive_metastore.ucx_sm5rw.ucx_tcdb4
18:15 DEBUG [databricks.labs.ucx.hive_metastore.table_migrate] Migrating external table hive_metastore.ucx_sm5rw.ucx_tcdb4 to using SQL query: SYNC TABLE ucx_cqb5x.ucx_sm5rw.ucx_tcdb4 FROM hive_metastore.ucx_sm5rw.ucx_tcdb4;
18:15 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.
18:15 CRITICAL [databricks.labs.blueprint.parallel] All 'migrate tables' tasks failed!!!
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 make_dbfs_data_copy fixtures
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/cm97
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/7Qah
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 table fixtures
18:15 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_sewdn.ucx_tttj2', metastore_id=None, name='ucx_tttj2', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sewdn', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/cm97', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:15 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_sm5rw.ucx_tcdb4', metastore_id=None, name='ucx_tcdb4', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sm5rw', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/7Qah', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 catalog fixtures
18:15 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=1711217731905, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cpoc4', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cpoc4', 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=1711217731905, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
18:15 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=1711217740484, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqb5x', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_cqb5x', 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=1711217740484, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 5 schema fixtures
18:15 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_sdcne', metastore_id=None, name='ucx_sdcne', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 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_sewdn', metastore_id=None, name='ucx_sewdn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cpoc4', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cpoc4.ucx_sewdn', metastore_id=None, name='ucx_sewdn', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 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_sm5rw', metastore_id=None, name='ucx_sm5rw', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:15 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_cqb5x', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_cqb5x.ucx_sm5rw', metastore_id=None, name='ucx_sm5rw', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw8] 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. (12m39.31s)
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.
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_srygd: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_srygd
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_srygd', metastore_id=None, name='ucx_srygd', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw5] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_srygd: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_srygd
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_srygd', metastore_id=None, name='ucx_srygd', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sbv1i: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sbv1i
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sbv1i', metastore_id=None, name='ucx_sbv1i', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sbv1i.ucx_tucfb: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sbv1i/ucx_tucfb
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sbv1i.ucx_tucfb', metastore_id=None, name='ucx_tucfb', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sbv1i', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sbv1i/ucx_tucfb', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/2v4l
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sbv1i.ucx_tgeyp: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sbv1i/ucx_tgeyp
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sbv1i.ucx_tgeyp', metastore_id=None, name='ucx_tgeyp', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sbv1i', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/2v4l', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1711217846283, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_ch5py', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_ch5py', 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=1711217846283, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_ch5py.ucx_sbv1i: https://DATABRICKS_HOST/explore/data/ucx_ch5py/ucx_sbv1i
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_ch5py', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_ch5py.ucx_sbv1i', metastore_id=None, name='ucx_sbv1i', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:22 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.ucx/config.yml) doesn't exist.
18:22 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
18:22 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.
18:22 INFO [databricks.labs.ucx.install] Fetching installations...
18:22 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
18:22 INFO [databricks.labs.ucx.install] Installing UCX v0.18.1+1020240323182207
18:22 INFO [databricks.labs.ucx.install] Creating dashboards...
18:22 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
18:22 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Estimates)...
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 01_0_group_migration.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 01_0_group_migration.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_metastore_assignment.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_metastore_assignment.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_data_modeling.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_data_modeling.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 03_0_data_migration.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 03_0_data_migration.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
18:22 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Main)...
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
18:22 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Azure)...
18:23 DEBUG [databricks.labs.ucx.installer.workflows] Creating jobs from tasks in main
18:23 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
18:23 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=099-destroy-schema
18:23 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.
18:23 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-tables job: https://DATABRICKS_HOST#job/905750453444563
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_srygd: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_srygd
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_srygd', metastore_id=None, name='ucx_srygd', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema hive_metastore.ucx_sbv1i: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sbv1i
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='hive_metastore', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='hive_metastore.ucx_sbv1i', metastore_id=None, name='ucx_sbv1i', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sbv1i.ucx_tucfb: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sbv1i/ucx_tucfb
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.DELTA: 'DELTA'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sbv1i.ucx_tucfb', metastore_id=None, name='ucx_tucfb', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sbv1i', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sbv1i/ucx_tucfb', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/2v4l
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Table hive_metastore.ucx_sbv1i.ucx_tgeyp: https://DATABRICKS_HOST/explore/data/hive_metastore/ucx_sbv1i/ucx_tgeyp
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added table fixture: TableInfo(access_point=None, browse_only=None, catalog_name='hive_metastore', columns=None, comment=None, created_at=None, created_by=None, data_access_configuration_id=None, data_source_format=<DataSourceFormat.CSV: 'CSV'>, deleted_at=None, delta_runtime_properties_kvpairs=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, encryption_details=None, full_name='hive_metastore.ucx_sbv1i.ucx_tgeyp', metastore_id=None, name='ucx_tgeyp', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sbv1i', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/2v4l', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added catalog fixture: CatalogInfo(browse_only=False, catalog_type=<CatalogType.MANAGED_CATALOG: 'MANAGED_CATALOG'>, comment='', connection_name=None, created_at=1711217846283, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_ch5py', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_ch5py', 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=1711217846283, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
18:17 INFO [databricks.labs.ucx.mixins.fixtures] Schema ucx_ch5py.ucx_sbv1i: https://DATABRICKS_HOST/explore/data/ucx_ch5py/ucx_sbv1i
18:17 DEBUG [databricks.labs.ucx.mixins.fixtures] added schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_ch5py', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_ch5py.ucx_sbv1i', metastore_id=None, name='ucx_sbv1i', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:22 DEBUG [databricks.labs.ucx.install] Cannot find previous installation: Path (/Users/0a330eb5-dd51-4d97-b6e4-c474356b1d5d/.ucx/config.yml) doesn't exist.
18:22 INFO [databricks.labs.ucx.install] Please answer a couple of questions to configure Unity Catalog migration
18:22 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.
18:22 INFO [databricks.labs.ucx.install] Fetching installations...
18:22 INFO [databricks.labs.ucx.installer.policy] Creating UCX cluster policy.
18:22 INFO [databricks.labs.ucx.install] Installing UCX v0.18.1+1020240323182207
18:22 INFO [databricks.labs.ucx.install] Creating dashboards...
18:22 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/views...
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Reading step folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment...
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/estimates...
18:22 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Estimates)...
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 01_0_group_migration.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 01_0_group_migration.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 00_0_metastore_assignment.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 00_0_metastore_assignment.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 02_0_data_modeling.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 02_0_data_modeling.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping query 03_0_data_migration.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Skipping viz 03_0_data_migration.md because it's a text widget
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/main...
18:22 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Main)...
18:22 DEBUG [databricks.labs.ucx.framework.dashboards] Reading dashboard folder /home/runner/work/ucx/ucx/src/databricks/labs/ucx/queries/assessment/CLOUD_ENV...
18:22 INFO [databricks.labs.ucx.framework.dashboards] Creating dashboard [UCX] UCX  Assessment (Azure)...
18:23 DEBUG [databricks.labs.ucx.installer.workflows] Creating jobs from tasks in main
18:23 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
18:23 INFO [databricks.labs.ucx.installer.mixins] Fetching warehouse_id from a config
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=assessment
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=remove-workspace-local-backup-groups
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-groups
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=migrate-tables
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=validate-groups-permissions
18:23 INFO [databricks.labs.ucx.installer.workflows] Creating new job configuration for step=099-destroy-schema
18:23 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.
18:23 DEBUG [databricks.labs.ucx.installer.workflows] starting migrate-tables job: https://DATABRICKS_HOST#job/905750453444563
18:29 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 make_dbfs_data_copy fixtures
18:29 DEBUG [databricks.labs.ucx.mixins.fixtures] removing make_dbfs_data_copy fixture: dbfs:/mnt/TEST_MOUNT_NAME/a/b/2v4l
18:29 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 2 table fixtures
18:29 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_sbv1i.ucx_tucfb', metastore_id=None, name='ucx_tucfb', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sbv1i', sql_path=None, storage_credential_name=None, storage_location='dbfs:/user/hive/warehouse/ucx_sbv1i/ucx_tucfb', table_constraints=None, table_id=None, table_type=<TableType.MANAGED: 'MANAGED'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:29 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_sbv1i.ucx_tgeyp', metastore_id=None, name='ucx_tgeyp', owner=None, pipeline_id=None, properties=None, row_filter=None, schema_name='ucx_sbv1i', sql_path=None, storage_credential_name=None, storage_location='dbfs:/mnt/TEST_MOUNT_NAME/a/b/2v4l', table_constraints=None, table_id=None, table_type=<TableType.EXTERNAL: 'EXTERNAL'>, updated_at=None, updated_by=None, view_definition=None, view_dependencies=None)
18:29 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 1 catalog fixtures
18:29 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=1711217846283, created_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d', effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_ch5py', isolation_mode=<IsolationMode.OPEN: 'OPEN'>, metastore_id='8952c1e3-b265-4adf-98c3-6f755e2e1453', name='ucx_ch5py', 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=1711217846283, updated_by='0a330eb5-dd51-4d97-b6e4-c474356b1d5d')
18:29 INFO [databricks.labs.ucx.install] Deleting UCX v0.18.1+1020240323182953 from https://DATABRICKS_HOST
18:29 INFO [databricks.labs.ucx.install] Deleting inventory database ucx_srygd
18:29 INFO [databricks.labs.ucx.install] Deleting jobs
18:29 INFO [databricks.labs.ucx.install] Deleting assessment job_id=824361894918449.
18:29 INFO [databricks.labs.ucx.install] Deleting remove-workspace-local-backup-groups job_id=416148639089455.
18:29 INFO [databricks.labs.ucx.install] Deleting migrate-groups job_id=1122888138439964.
18:29 INFO [databricks.labs.ucx.install] Deleting migrate-tables job_id=905750453444563.
18:29 INFO [databricks.labs.ucx.install] Deleting validate-groups-permissions job_id=671116469186851.
18:29 INFO [databricks.labs.ucx.install] Deleting 099-destroy-schema job_id=910623362649471.
18:29 INFO [databricks.labs.ucx.install] Deleting cluster policy
18:29 INFO [databricks.labs.ucx.install] Deleting secret scope
18:29 INFO [databricks.labs.ucx.install] UnInstalling UCX complete
18:29 DEBUG [databricks.labs.ucx.mixins.fixtures] clearing 3 schema fixtures
18:29 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_srygd', metastore_id=None, name='ucx_srygd', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:29 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_sbv1i', metastore_id=None, name='ucx_sbv1i', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
18:29 DEBUG [databricks.labs.ucx.mixins.fixtures] removing schema fixture: SchemaInfo(browse_only=None, catalog_name='ucx_ch5py', catalog_type=None, comment=None, created_at=None, created_by=None, effective_predictive_optimization_flag=None, enable_predictive_optimization=None, full_name='ucx_ch5py.ucx_sbv1i', metastore_id=None, name='ucx_sbv1i', owner=None, properties=None, storage_location=None, storage_root=None, updated_at=None, updated_by=None)
[gw5] linux -- Python 3.10.13 /home/runner/work/ucx/ucx/.venv/bin/python

Flaky tests:

  • 🤪 test_running_real_assessment_job (10m49.052s)

Running from acceptance #1726

Copy link
Collaborator

@nfx nfx left a comment

Choose a reason for hiding this comment

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

Lgtm

@nfx nfx merged commit bfc1a61 into main Mar 24, 2024
7 of 8 checks passed
@nfx nfx deleted the fix/account_grp_wrkspace_id branch March 24, 2024 08:35
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.

2 participants