bqml_gbm.sql

#standardSQL
CREATE MODEL 'bqml_tutorial.sample_model'
OPTIONS(model_type='boosted_tree_classifier') AS
SELECT
  IF(totals.transactions IS NULL, 0, 1) AS label,
  IFNULL(device.operatingSystem, "") as os,
  device.isMobile AS is_mobile,
  IFNULL(geoNetwork.country, "") AS country,
  IFNULL(totals.pageviews, 0) AS pageviews
FROM
  'bigquery-public-data.google_analytics_sample.ga_sessions_*'
WHERE
  _TABLE_SUFFIX BETWEEN '20160801' AND '20170630'