Allow customizing Data Filters for tables with permissions on columns
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 8h
- Merged PRs (30d)
- 188
Description
**Is your feature request related to a problem? Please describe.**
In postgres - you can grant `SELECT` on specific columns of a table.
Let's assume I have a table called `"Users"` and I gave user `testuser` `SELECT` permissions only on some of its columns.
While connected with user `testuser`:
When you try to view the table's properties - it works fine as expected.
When you try to view it's data - it fails due to the permission error because it tries to do a `select *` - also expected.
If you try to customize the `Data Filters` - the modal is empty and it's not possible to select specific columns

**Describe the solution you'd like**
Assuming `Data Filters` also affect the query being run (i.e specific columns instead of `*`) - the modal should rely on the metadata of the table for displaying the columns, rather than relying on the Data tab to actually load data.
If it does not - it should...
The goal is to continue working seamlessly with the Database Navigator and for example being able to click on the arrow of a FK value to load the parent table (i.e in table `Users`) and still be able to see the "allowed" columns without having to turn to raw SQL.
**Describe alternatives you've considered**
It's still possible to query the table using raw SQL in SQL Editor
Contributor guide
Assessment
This issue has not been assessed yet.