Skip to content

Latest commit

 

History

History
29 lines (25 loc) · 1.11 KB

README.md

File metadata and controls

29 lines (25 loc) · 1.11 KB

Automl

Goals

  • Test automl ci/cd pipeline.
  • Test retrain models on a frequent basis.

References

#standardSQL CREATE OR REPLACE MODEL bqml_codelab.sample_model OPTIONS(model_type='logistic_reg') 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 FROMbigquery-public-data.google_analytics_sample.ga_sessions_* WHERE _TABLE_SUFFIX BETWEEN '20160801' AND '20170631' LIMIT 100000;