Insight: Field-level Cleanup Suggestions
Note
We currently suggest to delete fields that:
- Are not used in any downstream tables
- Are not used in any BI reports
- Are not read in any SELECT query
- The table itself is not eligible for cleanup
Field Defintions
FULL_TABLE_ID : A concatenation of project, dataset and table name
PROJECT_NAME : As defined externally
DATASET_NAME : As defined externally(e.g. a schema in snowflake)
TABLE_NAME: As defined externally
TABLE_TYPE : Field values: table, view, external, wildcard_table
FIELD_TO_CLEANUP : A list of fields that can be removed
FIELD_TO_KEEP : A list of fields that should be kept
PERCENT_REMOVABLE : The % of fields in the table that can be deleted, the insight is sorted by this.
TABLE_IMPORTANCE_SCORE : The table importance score, the insight is sorted by this
Updated 10 months ago