Salesforce Aggregation Error

[KHSDM]

I'm getting the following error when trying to execute a Salesforce query:

Connector reply error: Unable to get column information for the fields that are used in the query. Please make sure you have only one SELECT statement in a query editor. Description: Aggregate functions are not supported by the connector.

I'm using the SOAP option, but still getting the error above. My query is something like this:

SELECT COUNT(Id), Created_From__c FROM <Object Name>__c  GROUP BY Created_From__c;

I can execute the query if I remove the aggregation.

Salesforce connector version: 15.212.0

[Vegar]

I am not sure about the connector specifics, but a workaround could be like this .

LOAD COUNT(Id), Created_From__c GROUP BY Created_From__c;

SELECT Id, Created_From__c FROM <Object Name>__c  GROUP BY Created_From__c;

Alternatively like this.

SF:

SELECT Id, Created_From__c FROM <Object Name>__c  GROUP BY Created_From__c;

FINAL:

LOAD COUNT(Id), Created_From__c RESIDENT SF GROUP BY Created_From__c;

DROP TABLE SF:

[KHSDM]

Hi Vegar,

Thanks for the suggestion. But we prefer to do the aggregation in SF as the original dataset is quite huge. So, we wanted SF to summarize the data before to extract it.