Skip to content

Instantly share code, notes, and snippets.

@janbenetka

janbenetka/random_sample_of_crtain_size.sql

Created July 21, 2022 10:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save janbenetka/fd6123f89c6d6eeab90ea16293830c01 to your computer and use it in GitHub Desktop.
Save janbenetka/fd6123f89c6d6eeab90ea16293830c01 to your computer and use it in GitHub Desktop.
Download ZIP
[Random sample in BQ] #bigquery #random
Raw
random_sample_of_crtain_size.sql
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