partitions_scanned missing from QUERY_HISTORY

Question

I am trying to get from my query history the pct_table_scan as

select
query_id
, (partitions_scanned / nullif(partitions_total,0)) * 100 as pct_table_scan
from table(information_schema.query_history());

from information_schema.query_history(). However, I see in the documentation that the partitions_% columns are available in the query_history from the account usage , which I don't have access to, but they are missing from the information_schema.query_history, which I can access. Is there any way I can access the partitions_% columns from the information schema?

Answer 1

As you see in the documentation, these columns are not available in the output of the table function (information_schema.query_history), so you can't access this information through the function.

You may submit a feature request to Snowflake Support to add these columns to the query_history table function.