For all of you who are using
snowflake dwh (Enterprise and above only):
The new feature on the access_history makes the query history analysis much faster and simpler.
It unlocks tons of use cases that we will support soon (lineage, performance and cost tracking on a query level, usage by table / user..).
It is a new column in the access_history view,
but it is not enabled by default.
This new data
only starts recording from the moment you enable it, no retro.
If you want to have it (by yourself or using Elementary, we will support it in a few days), we recommend you enable it:
-- This ENABLES the bundle
select system$enable_behavior_change_bundle('2021_10');
-- This CHECKS IF BUNDLE IS ENABLED
select system$behavior_change_bundle_status('2021_10');