The following api. functions are available:

• datamartFilter

• getDatamartContext

• getDatamartRowSet

• getTableContext

Once you obtain the DatamartContext, you can call its functions - see DatamartContext.

Groovy SQL Query API

If the standard query API lacks particular functions, expressions, and/or join modes, you can configure, in the Groovy logic, an SQL SELECT statement to be run against Analytics data. This way, the full power of SQL can be leveraged.

...

 For the executeSqlQuery function, the supported SQL syntax depends on the database server of Analytics where typically PostgreSQL 10+ or Greenplum 5.12+ are used.