Hi,
Greetings. Hope you are doing well! I am trying to run SQL queries against externalmktdata and based on this article
we should be adding a ExternalMKTData:DatabaseAdministrator role but i could not find this role and also i cannot see externalmktdata as a schema within the dropdown.
Any configuration that should be done?
I am on cloud with Pega infinity '24.1
Regards,
Bharat
ExternalMKTData:DatabaseAdministrator is available if you’re using Pega CDH.
@SohamM95 Hi, I am using Pega CDH but is not available or atleast i cannot see in my environment.
Regards,
Bharat
To run SQL queries against the ExternalMKTData database in Pega Cloud, you need to have the PegaRULES:DatabaseAdministrator role. If you can’t see the ExternalMKTData schema in the dropdown, it might be because the ExternalMKTData database rule is not properly configured. Please ensure that the ExternalMKTData database rule is correctly set up and that the user associated with the ExternalMKTData schema has the necessary grants to certain tables in the PegaDATA schema.
This is a GenAI-powered tool. All generated answers require validation against the provided references.
Installing the Pega Customer Decision Hub application > Creating the ExternalM
if you need further help please log a Cloud issue via the MSP.
@MarijeSchillern Hi, i have also checked in academy instance but that role is not available.
Regards,
Bharat
@MarijeSchillern I am facing the same issue. What has been the solution?
@SKashyap if you need assistance please log a Cloud issue via the MSP.
@KOMARINA if you need further help please log a Cloud issue via the MSP.