Same Query, Different Hash: Snowflake's query hashing blind spots

Really interesting! Could you clarify what difference having two different query_parameterized_hash for similar queries is? Is there a performance hit?