OpenMetadata
OpenMetadata copied to clipboard
When profiling Snowflake, allow users to choose between system and bernoulli sampling.
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 ;)