Last time, we talked about a query using the Query_History_By_User table function in Snowflake. This time, I want to discuss a similar table function named Query_History_By_Session. Thankfully, it works in a very similar fashion to Query_History_By_User. SELECT * FROM TABLE(SNOWFLAKE.INFORMATION_SCHEMA.QUERY_HISTORY_BY_USER()) ORDER BY START_TIME DESC; Yes, it shows the same information as Query_History_By_User, so I am…… Continue reading Querying History By Sessions in Snowflake
Month: July 2024
Cool Items in Snowflake that Aren’t in SQL Server
Yes, I know. The name of today’s post is certainly clickbait. But it’s true! There are so many things you can do in Snowflake that may – or may not – be possible in SQL Server, at least not without several tricks and possibly low-level querying. So, let’s start shall we? What did I run?…… Continue reading Cool Items in Snowflake that Aren’t in SQL Server