Operations Pushdowns

[Amir Ragaie]

Hello Support Team,
I am currently trying to develop a community connector for Looker Studio.

I have some few questions:

1. How to push down aggregations to the data source and by that I mean to access the aggregations performed in the request body sent in the getData() function - PostgresSQL connector can pushdown the aggregations to the Posgres DB .

here is a example of the request body visible for me

{ "configParams": {"table":"months","schema":"sales","fetchSize":"5"}, "fields":[{"name":"NAME"},{"name":"NUMBER"}], "scriptParams":{"lastRefresh":"1758425096065"} }

1. Same Question goes for the sorting operation. What if I want to return the data from the getData() function sorted? I also want to know the sorting mechanism set in the UI.
2. I saw in the documentation that the limit on the size of the getData() response is 1M rows, is there any method to return more than that (please list all possible solutions if any)
3. Is there any other limitations on the response body?

Thanks in advance