Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2022 06:49 AM
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.