Data Science, Machine Learning, Design Patterns, Bigquery, Sql.
single query as follows: CREATE OR REPLACE TABLE mydataset.mytable AS SELECT airline, departure_airport, departure_schedule, arrival_airport, arrival_delay, CASE(ABS(MOD(FARM_FINGERPRINT(date), 10))) WHEN 9 THEN 'test' WHEN 8 THEN 'validation' ELSE 'training' END AS split_col FROM