Generating a Random Number in BigQuery

If you're looking to generate a random number in BigQuery, check out the RAND() function. It's a pseudo-random number generator, generating a float in the interval [0, 1). I've used it a few times before, but for the today's exercise, I've decide to ...