Data Science, Machine Learning, Design Patterns, Bigquery, Sql.
arrival_delay FROM `bigquery-samples`.airline_ontime_data.flights f WHERE ABS(MOD(FARM_FINGERPRINT(TO_JSON_STRING(f)), 10)) < 8 Note that if you have duplicate rows, then they will always end up in the same split. If this is a concern, add a unique id column to your SELECT query.