select t.*, case when random() < 0.7 then 'training' else 'test' end as split from analytics.model_data_discharge_v1 t