Cloud services can help in pruning even if the columns are variant columns.

Cloud services can help in pruning even if the columns are variant columns.
A . TRUE
B. FALSE

View Answer

Answer: A

Explanation:

Snowflake stores internally variant (json) data, in a independent column like structure for the 100+ most common elements, and the remainder in a leftovers like column. Those virtual columns have min/max, distribution like stats like normal columns have. So, even for variant columns, snowflake can use metadata repository for query pruning.