Table | Description |
---|---|
InputTable | The alias, InputTable, is required only if you specify the optional Orders table. |
Orders | [Optional] TimeSeriesOrders Output table. If omitted, you must specify the PDQ syntax element. |
InputTable Schema
Column | Data Type | Description |
---|---|---|
timestamp_column | Any | [Column appears once for each specified timestamp_column.] Sequence (time points) of input value. If time points do not have uniform intervals, run Interpolator (ML Engine) function on them before running VARMAX function on input table. |
partition_column | Any allowed by Partition Key | [Column appears once for each specified partition_column.] Column by which input data is partitioned. |
target_column | Any numeric SQL data type | [Column appears once for each specified target_column.] Value of response variable. |
exogenous_column | Any numeric SQL data type | [Column appears once for each specified exogenous_column.] Value of exogenous variable. |
Each input time series must:
- Be an ordered sequence in a partition with uniform time intervals
- Fit into memory
- Not include NULL or numeric values, except as noted in the description of the ResponseColumns syntax element