Running SQL queries on Pega Cloud

As a Pega Cloud client, to retrieve data from the internal PegaDATA or PegaRULES databases, you can run SELECT statements using Query Runner.

Before you begin:

You need the PegaRULES:DatabaseAdministrator role to access Query Runner. For more information, see Adding a role to an access group.

You can run queries against non-binay large objects (BLOB) columns in your database, view the results, and export the results to an Excel spreadsheet or .pdf file. A maximum of 500 rows are returned for each query.

Note: Pega Cloud Services provides Query Runner, Query Inspector, and Schema Tools in Pega Platform for clients to manage their database. These database tools are not available to on-premises clients.

In the header of Dev Studio, click Configure > System > Database > Query Runner.
Click the Query Entry tab.
In the Choose your database field, select from the PegaRULES or PegaDATA databases that you want to run the query against.
In the SQL query field, enter the query that you want to test. The query must contain the fully qualified name of the table.
Click Run. Pega Platform displays the resulting SELECT SQL query in the RESULTS pane.