How to fetch certain column data from datasource?

I want to fetch the specified column from a data source(i.e. exclude certain columns) because even I don't show the data in UI, the data is loaded. (it is visible from Network tabs in Browser DevTools).

So far, I found the automatic data load and query builder/ query script provide the filters and sorting of the data but loads all the columns.

I have tried record owner security and role based security but this will make the data inaccessible to some users.

Solution

You can try creating a Calculated SQL Model to limit columns being pulled.

Let's take an example where you have a Student model with Name and City as the only two fields. You can add a new Calculated SQL with this SQL query and only Name column would be pulled.

SELECT Name FROM Student

Please refer to the official guide here. Feel free to comment if you want some clarification!

Hope this helps.