Full SQL documentation for Process Intelligence Backend?

[benedict_cbs_consulting]

Hi everyone,

when creating Data Views and Business Objects for SAP Signavio Process Intelligence Process Data Pipeline I am struggling to find a suitable list of SQL-functions that are available.

Following the Process Intelligence Guide ( Data Type Requirements for Process Data Pipelines | SAP Help Portal ) transformation scripts use AWS Athena, which is based on Trino. For a list of available SQL-functions the guide refers to the Trino Docuentation ( Trino documentation — List of functions and operators ). While this definitely helps, it seems to me that this is not the full answer.

Example:
I cannot get the function LISTAGG to work, which is discussed in the Trino documentation. I am trying to use the following code:

SELECT
  CONCAT(mandt, bukrs, belnr, gjahr) AS bkpf_c_key
  ,COUNT(buzei) AS buzei_count
  ,LISTAGG(bschl, ',') WITHIN GROUP (ORDER BY buzei) bschl_array
FROM bseg
GROUP BY CONCAT(mandt, bukrs, belnr, gjahr)

The following error message comes up:

Error: VALIDATION_ERROR
Error Id: d13e7b49-d445-4212-87ca-1efe2f720863Landscape: prod_cloud_os_euValidation
Error occurred: Syntax issue: mismatched input '(' expecting 'BY'

So it seems to me, the function is known, but the suggested code from the Trino guide is not working in the Signavio environment. Apparently there is some validation checking that GROUP has to be followed by BY.  And further after GROUP BY <attribute> the end of the file is expected. This essentially makes the LISTAGG function unuseable.

Can someone help me understand what is going on here? This is probably something similar to why it is necessary to give aliases for output columns, when in typical Trino it would not be...

Is there any kind of flawless documentation on which SQL-functions are available in the Signavio Backend?

Best,

Benedict

PS.: I can receive similar results to LISTAGG with the function ARRAY_AGG, but I am still curious why some functionality from the guide does not work.

SAP Signavio Process Intelligence