Table | Description |
---|---|
InputTable | Contains data sets to use to build models. Function builds one model for each partition. |
AttributeTable | [Optional] Contains predictors to use for specified partitions. If any input table partition key (which may have one or more columns) is not in AttributeTable, function uses all input table attributes specified by TargetColumns for that partition to build the model. If input table partition key is in AttributeTable, function replaces attributes specified in model with attributes specified in AttributeTable. If you omit AttributeTable, function uses every specified target column (every numeric_input_column and categorical_input_column) in every model. |
ParameterTable | [Optional] Contains model parameter values to use for specified partitions. If any input table partition is not in ParameterTable, function uses parameter values specified by syntax elements or default parameter value to build the model. If input table partition key is in ParameterTable, each parameter value in ParameterTable overrides corresponding parameter value specified by either syntax element or default. If you omit ParameterTable, function uses parameter values specified by syntax elements for every partition. |
InputTable Schema
Column | Data Type | Description |
---|---|---|
partition_column | VARCHAR | [Column appears once for each specified partition_column.] Column by which input table is partitioned. Function creates one model for each partition. |
response_column | VARCHAR | Dependent/response variable. If NULL, function ignores it. |
attribute_column | VARCHAR | [Column appears once for each specified numeric_input_column and categorical_input_column.] numeric_input_column or categorical_input_column in input table. |
AttributeTable Schema
Column | Data Type | Description |
---|---|---|
partition_column | Any allowed by Partition Key | [Column appears once for each specified partition_column.] Column on which to partition table. You must specify this column in PARTITION BY clause of input table. Partition columns must start in first column, be contiguous, and appear before attribute_column and value_column in the table. |
attribute_column | VARCHAR | Contains names of numeric and categorical input table columns. |
value_column | INTEGER | 1 for numeric attribute, 0 for categorical attribute. |
ParameterTable Schema
Column | Data Type | Description |
---|---|---|
partition_column | VARCHAR | [Column appears once for each specified partition_column.] Column on which to partition table. Partition columns must start in first column, be contiguous, and appear before attribute_column and value_column in the table. |
parameter_column | VARCHAR | One of the following syntax elements:
|
value_column | VARCHAR | Value to use for syntax element for partition. |