What aspect of an executed query is represented by the remote disk I/O statistic of the Query Profile in Snowflake?
A.
Time spent scanning the table partitions to filter data based on the predicate
B.
Time spent caching the data to remote storage in order to buffer the data being extracted and exported
C.
Time spent reading and writing data from and to remote storage when the data being accessed does not fit into the executing virtual warehouse node memory
D.
Time spent reading and writing data from and to remote storage when the data being accessed does not fit into either the virtual warehouse memory or the local disk
I think the correct answer is A
B - not correct
C - the correct metric for that would be Bytes spilled to local storage
D - the correct metric for that would be Bytes spilled to remote storage
A - correct, we're accessing the remote disk (the Storage Layer) to retrieve the data for the query.
https://community.snowflake.com/s/article/Performance-impact-from-local-and-remote-disk-spilling
https://community.snowflake.com/s/article/Performance-impact-from-local-and-remote-disk-spilling
https://community.snowflake.com/s/article/Performance-impact-from-local-and-remote-disk-spilling
Changing my mind to B.
We can cross-reference the options against this doc:
https://docs.snowflake.com/en/user-guide/ui-query-profile#statistics
A - Pruning
B - IO
C - Spilling
D- Spilling
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0e504b5
9 months ago0e504b5
9 months ago0e504b5
9 months ago0e504b5
9 months ago0e504b5
9 months agokayuhanbiduk
1 year agorajukg
1 year, 1 month agoVipinSingla
1 year, 2 months agoukpino
1 year, 3 months agoMultiCloudIronMan
1 year, 3 months agoMultiCloudIronMan
1 year, 3 months agoMultiCloudIronMan
1 year, 3 months ago