query-optimization snowflake-cloud-data-platform sql-delete

how to find out in snowflake ? who drop/deleted my table in snowflake?

I want complete rca for table deleted or drop in snowflake, not sure how the table got deleted. any hints how I can see who have deleted it ? as all the dependent pipes got failed.

Solution

You might be able to use the Access_History view. Details: https://docs.snowflake.com/en/user-guide/access-history.html#write-operations-in-the-access-history-view

Also, on more of when and who did it - query-history-view Details: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html#query-history-view

Why is Postgres not using my index on a simple ORDER BY LIMIT 1?
How many rows of data are deemed untenable and require a switch to a JSON column
Postgres caseinsensitive unique key constraint: What is the fast option?
Deleting millions of rows in MySQL
MySQL8 ORDER BY with JOIN uses filesort even though the result set is sorted already (based on indexes)
Hibernate @OneToOne executes multiple queries even with @Fetch(FetchMode.JOIN)
How can I simplify/improve the performance of this MySQL query?
Where should we do the filtering - at the data layer or the service layer to optimize testability and efficiency?
Fastest way to find which hours have 0 rows in a table with a month's data?
SQL Inner join with where clause works fast with one condition, but not when activeFlag is added
Why does TRY_CAST() / TRY_CONVERT() take so overly long for a view outer joined on itself but each side filtered on another String?
Slow MySQL query with multiple sub-queries in where clause
How to extract nested JSONB values in PostgreSQL with dynamic SQL query for a particular key?
Do duplicates in the IN statement have an impact on performance?
SQL Scan vs Seek when using OR in where criteria
Most efficient way to SELECT on a cluster table?
Mariadb / mysql EXPLAIN to optimize data query
How to optimize a query?
Improve processing time of applying a function over a vector and grouping by columns
Optimizing SQL join query with date comparison
How do I speed up this strftime('%Y-%m', time_UTC) query?
Why is PostgreSQL sorting a seemingly already sorted result set?
Why is the order page on my WooCommerce store so slow?
Postgres with row level security does not optimize queries / uses one-time filters
Dynamic SQL vs. generic query with dynamic filters
Optimizing Oracle query join on a range of values (join on n between x and y)
Performance of SQL query in a big table
Why are columns not in my SELECT coming in the output when looking at the execution plan?
MySQL functional index with IS NULL
Oracle SQL Index DATE vs Index TRUNC(DATE)