AmanSehgal
Honored Contributor III

Icons in query history explained:

  • Blue dotted circle means query is running
  • Hourglass icon means the query is queued
  • Red square means the query faile
  • Green tick means the query execution was successful

When a query execution finishes, it'll either have a red square or a green tick. Click on your query to see the metrics that opens up on right side of your screen. In the IO section you'll see:

  • Rows returned
  • Rows read
  • Bytes read
  • Bytes read from cache
  • Bytes written

In your python code, when you call `cursor.fetchall()`, then you can check how many rows did you receive and map that to query history output.

result = cursor.fetchall()
print(len(result))

Also, once your query execution finishes, the warehouse will shut down after defined minutes of inactivity or you can shut it down manually.