Insight: Field Health Suggestions
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
IMPORTANCE_SCORE : A score from 0-1 expressed as a decimal, this is score is based on number of reads, number of users (query executors), degree connectivity (i.e., table’s # of parent/child tables), update periodicity and age & freshness.
UPDATE_FREQUENCY_HOURS: The typical number of hours in the update cycle.
TOTAL_ROWS: A count of the total rows in the table
TOTAL_BYTES: A count of the total bytes in the table
ROWS_PER_DAY: usual count of rows updated per day
BYTES_PER_DAY: usual count of bytes updated per day
HAS_TIME_FIELD: A true/false boolean.
HAS_TXT_FIELD: A true/false boolean.
HAS_NUM_FIELD: A true/false boolean.
HAS_BOOL_FIELD: A true/false boolean.
DOMAINS: As created by the user in the UI.
Updated about 1 year ago