QUERY_HISTORY view
This Account Usage view can be used to query Snowflake query history by various dimensions (time range, session, user, warehouse, etc.) within the last 365 days (1 year).
I think is B and C - in the documentation when it uses the word persisted it talks about 24h period of retention, which is the result set retention time living in the service cloud layer. So i don't think D is correct.
https://docs.snowflake.com/en/user-guide/querying-persisted-results
Service Layer: Which accepts SQL requests from users, coordinates queries, managing transactions and results. Logically, this can be assumed to hold the result cache – a cached copy of the results of every query executed.
https://community.snowflake.com/s/article/Caching-in-the-Snowflake-Cloud-Data-Platform
D cannot be right because the services layer stores cache, not the the storage layer
https://docs.snowflake.com/en/user-guide/querying-persisted-results.html
Persisted here means cached, so Persisted Query Results is the query result cache which is in the cloud service layer, not storage layer
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
EmiB
Highly Voted 1 year, 7 months agoPrasantSadangi
Most Recent 3 weeks, 5 days agolevisn1
4 months, 1 week ago0e504b5
8 months, 3 weeks agoganeshra
10 months, 1 week ago[Removed]
11 months, 4 weeks agoSamuelZhang
1 year, 1 month agosinghks
1 year, 2 months agoMultiCloudIronMan
1 year, 3 months agovini15
1 year, 5 months agoKvk117
1 year, 6 months agoAS314
1 year, 9 months ago