如何查找在Snowflake中创建表的用户 [英] How to find the user who created a table in Snowflake

问题描述

我正在尝试查找Snowflake中的表的创建者。INFORMATION_SCHEMA表仅显示拥有它的角色。

浏览Query_History非常费力。

谢谢， SAM

Information_Schema和Show Tables命令。

推荐答案

在Snowlake.account_usage.query_History中随机搜索可能会很费力，但有针对性的搜索相当快捷简单，这对您应该有效。

SET dbName='DATABASE NAME HERE';
SET schemaName='SCHEMA NAME HERE';
SET tableName='TABLE NAME HERE';
SET create_dt=(
    SELECT MIN(created) 
    FROM snowflake.account_usage.tables 
    WHERE table_catalog = $dbName 
    AND table_schema = $schemaName 
    AND table_name = $tableName 
    AND deleted is null);

SELECT  * 
FROM   snowflake.account_usage.query_history
WHERE  query_text iLike '%CREATE%TABLE%'||$tableName||'%'
AND    execution_status = 'SUCCESS'
AND    start_time = $create_dt;

这篇关于如何查找在Snowflake中创建表的用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！