Insight: Table Cleanup Suggestions

📘

Note

In this insight we only show tables that have not read in the last 30 days.

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

DAYS_SINCE_LAST_WRITE: A count of the number of days since the last update to the table.

LAST_WRITE: A timestamp of the last update.

TOTAL_ROW_COUNT: A sum of the rows in the table.

TOTAL_BYTE_COUNT: A sum of the bytes in the table.