Do not allow to delete a staging table or Staging data from Unified tenant
Description
TSRE - Internal Support default text according to the team DoR (Definition of Ready)
01 - PERSON OF CONTACT (PERSON THAT CAN ANSWER QUESTIONS ABOUT THE PROBLEM):
@Douglas Coimbra Lopes
2 - DESCRIBE ALTERNATIVES YOU CONSIDERED:
- It is possible to delete a staging table from the Unified tenant that is part of copy data
- We should block the Unified tenant to delete any staging in the tenant that is referred on the SQL Manifest file.
03 STEPS
- Create a unified tenant
- Create a customer tenant
- Create a Carol app
- Attach the app to the Unified tenant
- Link the app with a GitHub repository
- Release and approve the app for installation
- Install the app on the customer and unified tenants
- From the UNIFIED tenant, try to drop one of the staging tables
- From the UNIFIED tenant, try to drop one of the connectors
04 - EXPECTED BEHAVIOR (LIST THE EXPECTED BEHAVIORS TO CONSIDER THIS BUG AS DONE) - ACCEPTANCE CRITERIA:
- We should block the Unified tenant from deleting any staging or connector in the tenant that is referred on the SQL Manifest file.
- We should block actions to delete data from staging tables that is referred on the SQL Manifest file.
- Flow “Delete Staging Table Records”
- Flows on intake to delete data (using crosswalk).
- Explorer should not allow data deletion as well.
- Only CAROL ADMIN are able to delete a staging or connector. Data deletion is blocked for everyone, including CAROL_ADMIN.