maxTk and Utilization Queries

SELECT max(tk) FROM dwh_capacity.date_dimension;
select tk,fulldate from dwh_capacity_efficiency.date_dimension where latest = 1;
 
SELECT
    Manufacturer
  , Family
  , Model
  , SUM(ROUND(rawCapacityMB / 1048576)) AS "Raw Capacity TB"
FROM dwh_inventory.storage
GROUP BY Model
ORDER BY 4 DESC;

SELECT
    SUM(ROUND(rawCapacityMB / 1048576)) AS "Raw Capacity TB"
FROM dwh_inventory.storage;