Which metadata table will store the storage utilization information even for dropped tables?
Which metadata table will store the storage utilization information even for dropped tables?
TABLE_STORAGE_METRICS displays table-level storage utilization information, which is used to calculate the storage billing for each table in the account, including tables that have been dropped but are still incurring storage costs.
"This view (TABLE_STORAGE_METRICS) displays table-level storage utilization information, which is used to calculate the storage billing for each table in the account, including tables that have been dropped, but are still incurring storage costs."
TABLE_STORAGE_METRICS View: This view displays table-level storage utilization information, which is used to calculate the storage billing for each table in the account, including tables that have been dropped, but are still incurring storage costs.
B https://docs.snowflake.com/en/sql-reference/info-schema/table_storage_metrics