In 3 ways we will ab able to view the query history,
1. Using SNOWSIGHT( Web UI)
2. Using INFORMATION_SCHEMA
SELECT * FROM TABLE (information_schema.query_history()) ORDER BY start_time;
3. Using ACCOUNT_USAGE
SELECT * FROM snowflake.account_usage.query_history;
No comments:
Post a Comment