bigquery_ml_0002.sql

CREATE MODEL `kaggle_talkingdata_adtracking.talkingdata_logreg_sample_0003`
OPTIONS (
  model_type='logistic_reg',
  input_label_cols=['is_attributed'],
  data_split_method='seq',
  data_split_col='click_time'
) AS
SELECT CAST(ip AS STRING) as ip,
  CAST(app AS STRING) as app,
  CAST(device AS STRING) as device,
  CAST(os AS STRING) as os,
  CAST(channel AS STRING) as channel,
  click_time,
  is_attributed
FROM `kaggle_talkingdata_adtracking.dataset_train_sample`;