Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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