Extracting table freshness and volume from Snowflake

snowflake_table_freshness_volume.sql

SELECT 
  TABLE_CATALOG, 
  TABLE_SCHEMA, 
  TABLE_NAME, 
  ROW_COUNT, 
  BYTES, 
  CONVERT_TIMEZONE('UTC', CREATED) as CREATED, 
  CONVERT_TIMEZONE('UTC', LAST_ALTERED) as LAST_ALTERED 
FROM "ANALYTICS".information_schema.tables 
WHERE 
  table_schema NOT IN ('INFORMATION_SCHEMA') 
  AND TABLE_TYPE NOT IN ('VIEW', 'EXTERNAL TABLE')
ORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME;