0
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

Snowflakeでクエリ履歴からクエリを検索する方法

Posted at

あのテーブルを作ったときのINSERT文はなんだっけと調べるときに調べる方法です。

use role ACCOUNTADMIN;

select * from snowflake.account_usage.query_history where query_text ilike 'insert%ano_table%';
0
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?