OpenMetadata icon indicating copy to clipboard operation
OpenMetadata copied to clipboard

When profiling Snowflake, allow users to choose between system and bernoulli sampling.

Open hendrix04 opened this issue 2 years ago • 7 comments

Is your feature request related to a problem? Please describe. Task #8336 made a change to use bernoulli for sampling so that views could be sampled. Turns out that the performance hit due to this is much larger than one might have expected. One of my table scans went from a 1 minute scan to a 13 minute scan due to the change.

Describe the solution you'd like When profiling a Snowflake table, allow users to choose what type of sampling that they want to use.

Describe alternatives you've considered Spending a lot of money on long running queries ;)

hendrix04 avatar Oct 28 '22 17:10 hendrix04