The History page allows you to view and drill into the details of all queries executed in the last 14 days. The page displays a historical listing of queries, including queries executed from SnowSQL or other SQL clients. The default information displayed for each query includes: Show
Note The Start Time and End Time columns display times in the logged-in user’s time zone. There is no option to change this setting. Session parameters do not affect this setting. In this Topic: Overview of Features¶Note The History page columns are derived from the QUERY_HISTORY view. See QUERY_HISTORY View for more information, including column descriptions. You can perform the following tasks in the History page:
Note The History page displays queries executed in the last 14 days, starting with the most recent ones. You can use the End Time filter to display queries based on a specified date; however, if you specify a date earlier than the last 14 days, no results are returned. Viewing Query Details and Results¶Snowflake persists the result of a query for a period of time, after which the result is purged. This limit is not adjustable. For more information, see Using Persisted Query Results. To view the details and result for a particular query, click the Query ID in the History page. The Query Detail page appears (see below), where you can view query execution details, as well as the query result (if still available). You can also use the Export Result button to export the result of the query (if still available) to a file. Note You can view results only for queries you have executed. If you have privileges to view queries executed by another user, the Query Detail page displays the details for the query, but, for data privacy reasons, the page does not display the actual query result. Exporting Query Results¶On any page in the interface where you can view the result of a query (e.g. Worksheets, Query Detail), if the query result is still available, you can export the result to a file. When you click the Export Result button for a query, you are prompted to specify the file name and format. Snowflake supports the following file formats for query export:
Note
Viewing Query Profile¶In addition to query details and results, Snowflake provides the Query Profile for analyzing query statistics and details, including the individual execution components that comprise the query. For more information, see Analyzing Queries Using Query Profile. |