BigQuery Create ML Regression Model

QueryStash

BigQuery Create ML Regression Model

1CREATE OR REPLACE MODEL `query-stash.house_price_model`
2OPTIONS (
3  model_type='linear_reg',
4  input_label_cols=['house_price']
5) AS
6SELECT *
7FROM `query-stash.houses_train`

CREATE OR REPLACE MODEL `query-stash.house_price_model`
OPTIONS (
  model_type='linear_reg',
  input_label_cols=['house_price']
) AS
SELECT *
FROM `query-stash.houses_train`

Public

bigquery ml

QueryStash

Created: Jan 12th 2023

QueryStash

Made with ❤️ by @Yekalb

Twitter Facebook Email

Resources

Blog Pricing Your First Query Search Your Stash

Examples

Merge Statements Persistent Functions Spike Detection QUALIFY Statement BigQuery ML Models

Stay up to date