Running SQL queries on Pega Cloud
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
Accepted Solution
Updated: 11 Jun 2024 7:56 EDT
Pegasystems Inc.
GB
@KOMARINA if you need further help please log a Cloud issue via the MSP.
Updated: 11 Jun 2024 6:50 EDT
Maantic Inc
IN
ExternalMKTData:DatabaseAdministrator is available if you're using Pega CDH.
Pegasystems Inc.
GB
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.
Accenture
GB
@MarijeSchillern Hi, i have also checked in academy instance but that role is not available.
Regards,
Bharat
Accepted Solution
Updated: 11 Jun 2024 7:56 EDT
Pegasystems Inc.
GB
@KOMARINA if you need further help please log a Cloud issue via the MSP.