(I am not affiliated with Keebo, although I had a recruiting meeting with them earlier this year)
FWIW, Keebo (https://keebo.ai/) tries to solve this problem & reduce your Snowflake bill by using Data Learning techniques. It can be configured to return exact results or approximate results.