Snowflake snippets
How to find the average daily space used for storage in the last 7 days
If you want to query the Information Schema to find for each database, the amount of space used for storage data in the last 7 days you can use the following query
SELECT *
FROM TABLE (
INFORMATION_SCHEMA.database_storage_usage_history
(DATEADD('days', -7, CURRENT_DATE()), CURRENT_DATE())
);
![Snowflake snippet 15](static/img/CookBook/Snowflake/IMG_015.png)
If you want to just extract the storage statistics about a specific database (for instance 'JOB_DATASET'
), you can personalize the query as the following
SELECT *
FROM TABLE(
INFORMATION_SCHEMA.database_storage_usage_history
(DATEADD('days',-7,CURRENT_DATE()),CURRENT_DATE(),'JOB_DATASET')
);
![Snowflake snippet 16](static/img/CookBook/Snowflake/IMG_016.png)