What does it mean when the sample function uses the Bernoulli sampling method?
What does it mean when the sample function uses the Bernoulli sampling method?
The Bernoulli sampling method means that the data is based on sampling each row individually. In this method, each row is included in the sample with a specified probability, similar to flipping a weighted coin for each row.
BERNOULLI (or ROW): Includes each row with a probability of p/100. Similar to flipping a weighted coin for each row. SYSTEM (or BLOCK): Includes each block of rows with a probability of p/100. Similar to flipping a weighted coin for each block of rows. This method does not support fixed-size sampling. Sampling method is optional. If no method is specified, the default is BERNOULLI.
https://docs.snowflake.com/en/sql-reference/constructs/sample#syntax
BERNOULLI (or ROW): Includes each row with a probability of p/100. Similar to flipping a weighted coin for each row.
BERNOULLI (or ROW): Includes each row with a probability of p/100. Similar to flipping a weighted coin for each row.
Each row
correct