A Snowflake Architect anticipates that a table will contain several terabytes of data, and so defines a custom cluster key of three columns to optimize query performance. However, the table still takes a long time to query.
Why is this occurring?
A.
A multi-cluster virtual warehouse is not being used.
B.
The cluster key should not exceed two columns.
C.
The custom cluster key cardinality is too high.
D.
The table needs to be manually reclustered to partition the key.
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.
ArunH
1 day, 1 hour ago