Skip to content

Instantly share code, notes, and snippets.

@davideanastasia

davideanastasia/bigquery_ml_0001.sql

Created October 11, 2018 20:19
Show Gist options
  • Save davideanastasia/5e2a143c0fba9c1f30505a4eef22efec to your computer and use it in GitHub Desktop.
Save davideanastasia/5e2a143c0fba9c1f30505a4eef22efec to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bigquery_ml_0001.sql
CREATE MODEL `kaggle_talkingdata_adtracking.talkingdata_logreg_sample`
OPTIONS (
model_type='logistic_reg',
input_label_cols=['is_attributed']
) AS
SELECT ip,
app,
device,
os,
channel,
is_attributed
FROM `kaggle_talkingdata_adtracking.dataset_train_sample`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment