Insight: Field Health Suggestions

Field Definitions

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.