Restrict view to specific columns in table

[zacherygrew]

Good afternoon!

Is there any way to restrict access to specific columns in a table?

For example I’m using the server to allow the client access to the users table.

I would like the client side to view all the columns in that table except 3.

I just can not find anyway to do it.

Any suggestions?

Thank you!

[stucork]

Update (2023): This feature has now shipped, and you can choose which columns are available in any view!

---

Original post:

Hi @zacherygrew and welcome to the forum,

You might find this linked feature request useful:

[DONE] Client-readable views on a subset of columns

Often, one must record housekeeping information in a row, e.g., transaction id for an item purchased. This is usually put in its own set of columns, separate from the columns that a user should see. Existing mechanisms can filter the rows, so that a user can see only the rows they “own”, but (unless I’m missing something) it doesn’t filter out app-private columns. But if we leave that to Python code, then we have to return the result as a list of dicts. Unfortunately, returning an accurate l…