Do not allow the customer to delete staging tables that are part of the Copy Data SQL Pipeline list

Description

PRDE - Story 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

02 - STORY BRIEFING (AS A < PERSONA >, I [WANT TO] < NEED >, [SO THAT] < GOAL >):
03 - PROBLEM (WHAT'S THE CURRENT PROBLEM SCENARIO OR PAIN TO BE RESOLVED?):

  • Once we perform the Copy Data from a customer tenant to the unified list, we should find a way to avoid the user dropping staging tables that are part of the SQL manifest pipeline for copy data.

  • For this case, we’re copying data from stg_nlp_purchaseorder & stg_nlp_product

  • Nowadays, the customer is able to delete any of the staging tables that are being copied from the unified tenant

  • The staging table has been dropped from the customer tenant

04 - GOAL (DESCRIBE THE PROPOSED SOLUTION):
05 - WHO CAN USE THIS FEATURE (USER ROLES):
06 - ACTIVITY DIAGRAM (ACTIVITY DIAGRAM LINK AND IMAGE):
07 - STEPS (ACTIONS TO BE PERFORMED LINKING TO SCREENSHOTS):

  • 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
  • Add the customer to the Allowed list (If the app is a hybrid SQL Strategy)
  • From the Customer tenant, try to drop one of the staging tables that are part of the copy data.

08 - ALTERNATIVE STEPS:
09 - ASSETS (FIGMA LINKS, RELEVANT DOCUMENTATION LINKS, JSON EXAMPLES, ETC):
10 - ACCEPTANCE CRITERIA:

  • Must block drop STG when it belongs to pipeline manifest = Look at the Tenant Mapping.