Skip to content

Instantly share code, notes, and snippets.

@doit-mattporter

doit-mattporter/temperature_automl_model.sh

Created February 6, 2021 00:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save doit-mattporter/90f25646cfc1d16e21a793ed87ea1c9a to your computer and use it in GitHub Desktop.
Save doit-mattporter/90f25646cfc1d16e21a793ed87ea1c9a to your computer and use it in GitHub Desktop.
Download ZIP
Construct an AutoML model
Raw
temperature_automl_model.sh
# Construct AutoML model
bq query --nouse_legacy_sql \
"CREATE OR REPLACE MODEL ${PROJECT_ID}.sensordata.temperature_automl_model
OPTIONS(MODEL_TYPE=\"AUTOML_CLASSIFIER\",
BUDGET_HOURS=24.0,
INPUT_LABEL_COLS=[\"object_code\"])
AS SELECT * EXCEPT (timestamp_utc, timestamp_epoch) FROM ${PROJECT_ID}.sensordata.temperature_pivoted_timediff"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment