Viewing SQL for Model Nuggets

For some models, SQL for the model nugget can be generated, pushing back the model scoring stage to the database. The main use of this feature is not to improve performance, but to allow streams containing these nuggets to have their full SQL pushed back. See the topic Nodes supporting SQL generation for more information.

To view the SQL for a model nugget that supports SQL generation:

1. Select the Settings tab on the model nugget.
2. Choose one of the options Generate with (no) missing value support or Generate SQL for this model, as appropriate.
3. In the model nugget menu, choose:

   File > Export SQL

4. Save the file.
5. Open the file to view the SQL.