- On the Free Form SQL dialog box, click on INPUT.
Click data selection.
Free Form SQL > Input > Data Select
This panel is not needed in the Teradata Profiler product and is therefore not displayed therein.
A standard column selector form is displayed with instructions stating that this form may be used to indicate the output columns created by this analysis or the input columns (model variables) if it creates a score table. When used to indicate output columns, these columns are used to determine what columns may be selected from this analysis when it is selected as an analysis input source. When used to indicate the input columns of a scoring analysis that is being refreshed or published, the Refresh or Publish analysis can use this information to limit columns in any “selectable” analyses (other than Free Form SQL analyses) referenced by it.
If the free-form SQL text specified for this analysis uses “special use” substitution parameters for Output Database and Output Table and builds an analytic data set (and not a score table), the display of this form will use those values to attempt to pre-set the Available Databases, Tables and Columns, provided columns have not been selected thus far. For this reason, it is useful to run the analysis first, creating the output table, and then use this form to declare what the output columns are. As an alternative to using this short-cut, any table containing the data set or model columns can be used to select the appropriate columns. Note that it is only the column names that are used by the Refresh or Publish analysis in limiting the columns in referenced analyses, but the column types are also important when the analysis is referenced for input.
Similarly, if the free-form SQL text specified for this analysis uses “special use” literal parameters for Input Database and Input Table and builds a score table (i.e., the Creates Score Table option is selected on the literal parameters tab), the display of this form will use those values to attempt to pre-set the Available Databases, Tables and Columns, provided columns have not been selected thus far. In other words, it is the output of a data set analysis or the input to a scoring analysis that defines the “variables in the model” that are being defined here.
Finally, note that even if this tab or panel is not used to specify output columns, it may still be possible to successfully reference a Free Form SQL analysis for input. If the special use parameters for Output Database and Output Table or View are specified, the Teradata data dictionary is queried to get column and index information. If on the other hand the Free Form SQL analysis either selects data or defines a Table Function or Operator, and the Generate Sql Only option (and the Table Function or Operator option if applicable) is checked, the output columns are determined, if possible, using a special technique involving the Teradata data dictionary.