SELECT warehouse_name,
SUM(credits_used) AS total_credits
FROM SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY
WHERE start_time >= DATEADD('day', -30, CURRENT_TIMESTAMP())
GROUP BY warehouse_name
ORDER BY total_credits DESC;
QUERY_HISTORY
紀錄帳戶中的每個查詢
SELECT query_text,
warehouse_name,
execution_time,
bytes_scanned
FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY
WHERE start_time >= DATEADD('day', -7, CURRENT_TIMESTAMP())
ORDER BY execution_time DESC
LIMIT 10;
STORAGE_USAGE
追蹤帳戶使用了多少儲存空間
包含使用中與 Fail-safe 儲存
SELECT usage_date,
ROUND(storage_bytes / POWER(1024, 3), 2) AS storage_gb,
ROUND(failsafe_bytes / POWER(1024, 3), 2) AS failsafe_gb
FROM SNOWFLAKE.ACCOUNT_USAGE.STORAGE_USAGE
ORDER BY usage_date DESC
LIMIT 30;
LOGIN_HISTORY
紀錄針對帳戶的每次登入嘗試
無論成功或失敗
SELECT user_name,
event_timestamp,
reported_client_type,
error_code,
error_message
FROM SNOWFLAKE.ACCOUNT_USAGE.LOGIN_HISTORY
WHERE error_code IS NOT NULL
AND event_timestamp >= DATEADD('day', -7, CURRENT_TIMESTAMP())
ORDER BY event_timestamp DESC;
Preparing Video For Download...
