janbenetka/random_sample_of_crtain_size.sql

Created July 21, 2022 10:22

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/janbenetka/fd6123f89c6d6eeab90ea16293830c01.js"></script>
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