How to delete or drop exposed columns in Pega cloud set up?

General
1

How to delete properties and DB columns in Pega cloud set up ? thanks

2

I think this requires manual deletion. Before removing the property and database column, ensure there are no remaining references to the property and verify any external class mappings that may depend on it.

3

To delete the columns in DB, there are two ways of doing it.

  1. You can write a query in connect-SQL rule and run it using an activity.
    OR
  2. Raise a CC to Pega support with all the details.
4

Thank you, there is a DB wizard, it has delete column checkbox so I was wondering if we can leverage that too in PROD, I know it works in the dev!!

5

yes but I was wondering if anyone has used delete column option from DB wizard in prod. It works in the dev but I was trying to make sure it works in prod too, thank you

6

I would recommend to push DADT instance from Dev to higher environments. This is to ensure that we have the same columns across all environments. This will help you if you optimize new columns, then it will be consistent across all environments.

7

Hi @SharadK17674862 ,

We can do in 3 ways

  1. Click on → Configure > System > Database > Optimize Schema

    Yes, you can delete it if it is the unused column. I did many times

    However, if the column contains data, you won’t be able to delete it. The column will not be dropped.

    click Configure > System > Database > Optimize Schema

image
image1918×742 63.4 KB

OR

  1. You can create an Activity then using the RDB method and a Connect SQL rule

OR

  1. You can raise a CC request in the MSP portal and provide the DROP COLUMN query for the respective column. The Pega team will take the necessary action on your behalf.

I hope this will help you

Thanks,

Ashok

8

Hey Sarad, we addressed this a few weeks ago. We created the SQL to drop the columns and raised a cloud change request, which resolved the issue