GET_QUERY_OPERATOR_STATS: Another Blunder from Snowflake?

Almost two years ago I wrote about the new GET_QUERY_OPERATOR_STATS system function released by Snowflake, and supposed to offer programmatic functionality to their users. The post is still on Snowflake’s blog and I was showing one way to create your own Query Profile.

Read here the post for free if you do not have a Medium subscription.

I recently published this as well in my new Streamlit in Snowflake Application Cookbook course on Udemy:

However, the main purpose of such a function was to offer automation. In this interesting thread from StackOverflow we get more info about how everything evolved in time:

We have someone asking how to access Snowflake query profile statistics via SQL. This was in 2022 and we had no programmatic access at that time.

Two Snowflake employees and a “Data Superhero” gradually come up with updates:

Bad news: There’s no programmatic way to get this.

Good news: This is a…