How can a data analyst determine if query results were pulled from the cache?
Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.
Go to the Alerts tab and check the Cache Status alert.
Go to the Queries tab and click on Cache Status. The status will be green if the results from the last run came from the cache.
Go to the SQL Warehouse (formerly SQL Endpoints) tab and click on Cache. The Cache file will show the contents of the cache.
Go to the Data tab and click Last Query. The details of the query will show if the results came from the cache.