Skip to content

Instantly share code, notes, and snippets.

@janbenetka
Created July 21, 2022 10:22
Show Gist options
  • Save janbenetka/fd6123f89c6d6eeab90ea16293830c01 to your computer and use it in GitHub Desktop.
Save janbenetka/fd6123f89c6d6eeab90ea16293830c01 to your computer and use it in GitHub Desktop.
[Random sample in BQ] #bigquery #random
SELECT * FROM subset
WHERE RAND() < 1e6 / (SELECT COUNT(*) FROM subset)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment