Currently, ZDP requires a unique combination of Source platform, source schema and technical name. However, there are scenarios when these fields becomes a constraint and restricts users to perform hive inventory action.
Use case:
Cataloging 2 tables with same name under different schema from hive database.
In this scenario, user will fill in details in Hive inventory as following:
SS: Undefined
SP: Undefined
Technical name: Table_Z
Target schema: Hive_DB_1
Now if a table with same name exists in other hive DB, user will fill in details like:
SS: Undefined
SP: Undefined
Technical name: Table_Z
Target schema: Hive_DB_2
The second hive inventory would fail because combination of source schema, source platform and technical would not be unique.
We need a permanent solution to address this problem.
Support Ticket | https://zaloni.atlassian.net/browse/PS-19576 |
Customer Impact | Major inconvenience |