Snowflake : espace disque utilisé

SELECT
            USAGE_DATE,
             (STORAGE_BYTES + STAGE_BYTES + FAILSAFE_BYTES) / (1024*1024*1024*1024) AS TOTAL_TB
FROM SNOWFLAKE.ACCOUNT_USAGE.STORAGE_USAGE
ORDER BY USAGE_DATE DESC
LIMIT 1;

ℹ️  LIMIT 1 : donne pour le jour courant , il suffit d'enlever le 'LIMIT pour voir jour par jour l'espace utilisé depuis la création

SELECT
       USAGE_DATE,
       STORAGE_BYTES / POWER(1024, 3) AS STORAGE_GB,
       STAGE_BYTES / POWER(1024, 3) AS STAGE_GB,
       FAILSAFE_BYTES / POWER(1024, 3) AS FAILSAFE_GB,
       (STORAGE_BYTES + STAGE_BYTES + FAILSAFE_BYTES) / POWER(1024, 3) AS TOTAL_GB
FROM SNOWFLAKE.ACCOUNT_USAGE.STORAGE_USAGE
ORDER BY USAGE_DATE DESC
LIMIT 1;