Skip to content

Instantly share code, notes, and snippets.

@Veenap

Veenap/Generating the model in BigQueryML

Last active May 22, 2020 12:40
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 Veenap/12ba07e2a55fcd6f3c850f408c223f00 to your computer and use it in GitHub Desktop.
Save Veenap/12ba07e2a55fcd6f3c850f408c223f00 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Generating the model in BigQueryML
CREATE OR REPLACE MODEL `BigQueryMLModel
OPTIONS (model_type='LOGISTIC_REG',auto_class_weights=TRUE,data_split_method='NO_SPLIT', input_label_cols=['within_3_days'],max_iterations = 15)
AS SELECT anonymous_id,first_spin_to_first_pay,total_jackpot,total_bet,total_win,total_spins, number_of_distinct_games, event_count,coin_balance,SUM_WIN_BY_BET, within_3_days
FROM '3DAY_CHURN_MODEL_ALL_FEATURES'
WHERE dataframe = 'training'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment