Eulogio, the only way to do this is to create an Apex REST API in Salesforce that performs the aggregate queries on the data and exposes it regardless of sharing settings. You can then use a REST Model in Skuid to retrieve data from this custom REST API and display it within Skuid. 

Thanks for the recommendation Zach! I’ll try your method.

Hi Zach,

I was able to create a RestResource and connect it to Skuid via a REST model, but I’m not able to get any data to come through.  This is what I’m receiving:

{type: "TBC_Demographics_Survey_Response__c", url: "/services/data/v42.0/sobjects/TBC_Demographics_Survey_Response__c/a5L80000000643wEAA", __skuid_record__: ba}

Not sure if this request is within your scope of obligation, but do you know what may be causing this? How do I get my data to pipe through instead of this url? My Apex class is returning a list of objects, but the data itself does not come through. Any advice would be appreciated.


Thanks!
Eulogio

Ignore my last message! I figured out what was wrong, I had an incorrect ‘Path to Contents’. Thanks anyways

Glad you got it working! 

Could you share your solution? I too have the same request, but I need to create records on an object that my users don’t have access to.