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())
;
[Snowflake]如何获取7天之前创建的数据库
最新推荐文章于 2024-10-09 12:58:26 发布