We are working on a POC and we wanted to know what are the necessary steps to add one more schema to the default admin,data,rules schemas. We want to add an archive schema, and use the OOTB Archive/Purge functionality to archive from the data schema into the archive schema and maintain the same rules schemas.
***Edited by Moderator Marissa to update platform capability tags****
Hope you are doing good. You just have to create a new database instance to map it to to the new schema and also the account id used to access the rules and data schema should also have necessary privileges to that archive schema. Let me know if you have any further questions.