Snowflake – Where is the explain/execution plan?

Whatever your database background is you will have heard of an execution / explain plan. Snowflake is no different. Coming from a MS SQL background I was used to reading plans from right to left. Now it is bottom to the top!

Enough talk let’s see one. I connect and issue a random query.

Where you see the tick and Query_ID link, click that and you will see the query ID to drill into.

20 seconds, 20 million rows, 2.3GB worth of scanned data ( no query result cache entry here)

Not exactly efficient in terms of partition pruning but that’s for another day.

1 thought on “Snowflake – Where is the explain/execution plan?

  1. Pingback: Showing a Query Plan in Snowflake – Curated SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s