TD_TargetEncodingFit ( ON {table | view | (query)} AS InputTable ON {table | view | (query)} AS CategoryTable DIMENSION [ OUT [ PERMANENT | VOLATILE ] TABLE OutputTable (output_table_name)] USING EncoderMethod({'CBM_BETA' | 'CBM_DIRICHLET' | 'CBM_GAUSSIAN_INVERSE_GAMMA'}) TargetColumns ({'target_column' | 'target_column_range'} [,... ]) ResponseColumn ('response_column') [AlphaPrior(alpha_prior_value)] [BetaPrior(beta_prior_value)] [AlphaPriors(list_of_values)] [NumDistinctResponses(num_distinct_responses)] [U0Prior(u0_prior_value)] [V0Prior(v0_prior_value)] [Alpha0Prior(alpha0_prior_value)] [Beta0Prior(beta0_prior_value)] [DefaultValues ({ default_value | default_value_i, ... })] )
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement