Skip to content

Instantly share code, notes, and snippets.

@eileen-code4fun

eileen-code4fun/cifar10_bq_model.sql

Created June 4, 2021 02:28
Show Gist options
  • Save eileen-code4fun/a124892429bb0ec7d32d9e08d54a9139 to your computer and use it in GitHub Desktop.
Save eileen-code4fun/a124892429bb0ec7d32d9e08d54a9139 to your computer and use it in GitHub Desktop.
Download ZIP
CIFAR10 BQ MODEL
Raw
cifar10_bq_model.sql
CREATE MODEL
# Name of the model.
`bqml.e2e-tutorial`
OPTIONS
# BigQuery will detect that it's for multiclass.
( MODEL_TYPE='LOGISTIC_REG') AS
SELECT
# Use the first column as the label.
int64_field_0 as label,
# The rest are features.
* EXCEPT (int64_field_0)
FROM
# Data taken from the train table.
`bqml.train`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment