ucx
ucx copied to clipboard
Update Table History Logs fails
Is there an existing issue for this?
- [x] I have searched the existing issues
Current Behavior
update_table_history_log task of migrate tables workflow fails.
[SCHEMA_NOT_FOUND] The schema `ucx.multiworkspace` cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a catalog, verify the current_schema() output, or qualify the name with the correct catalog.
To tolerate the error on drop use DROP SCHEMA IF EXISTS. SQLSTATE: 42704```
### Expected Behavior
We expect the task to succeed or fail gracefully.
### Steps To Reproduce
_No response_
### Cloud
AWS
### Operating System
macOS
### Version
latest via Databricks CLI
### Relevant log output
```shell
@FastLee : Could you add some more context to this issue? Where did it fail? In our integration tests? By a user?
It fails because we have an undocumented dependency on a UC Catalog
In that case, we should update the workflow to not fail if the dependency is not fulfilled, we should only append the log if we can.
Note that this is an almost duplicate of #3438 and would be less likely to happen if #2737 is implemented