[Snowflake]如何获取7天之前创建的数据库

[Snowflake]如何获取7天之前创建的数据库

SELECt DATAbase_NAME AS "Database"
FROM INFORMATION_SCHEMA.DATAbaseS
WHERe DATAbase_NAME LIKE '%Data'
AND DATAbase_OWNER = 'SYSADMIN'
AND CREATED <= DATEADD(DAY,-1,current_timestamp())
;