Extracting table metadata from Snowflake

snowflake_table_metadata.sql

SELECT 
  TABLE_CATALOG, 
  TABLE_SCHEMA,
  TABLE_NAME, 
  TABLE_OWNER, 
  TABLE_TYPE, 
  IS_TRANSIENT, 
  RETENTION_TIME, 
  AUTO_CLUSTERING_ON, 
  COMMENT 
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;