Include basic column statistics in column information view
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 8h
- Merged PRs (30d)
- 188
Description
(Please excuse me if this feature request has already been discussed)
When exploring new databases and performing basic content checks I regularly evaluate database columns for "completeness" (how many fields per column are non-null/non-empty) and the most frequent values (usually the most frequent 3 values).
The background for this inspection is that many databases schemas have unused or overlooked fields that are intended to be populated with meaningful values but are neglected by users so that they will largely contain default or NULL values. Performing such a simple analysis requires some dynamic programming (e.g. adjusting frequnency counts for column names and data types) which feels like repeating a lot of work that has already been done under the hood of dbeaver.
The table/column information view quite already provides basic schema data, and lists data types, constraints, comments and others. It would be great to have a mechanism to extend this view with column statistics, i.e. trigger a computation of the share of non-null field values or the computation of the most frequent values.
Contributor guide
Assessment
This issue has not been assessed yet.