Ideas
Status On the Backlog
Categories Catalog
Created by Ajinkya Rasam
Created on Feb 7, 2020

Remove SS & SP unique constraint while cataloging

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
  • Attach files