1.1 - Saving a Model Query or Selected Results - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst with Machine Learning Engine User Guide

Product
Teradata Analytic Apps
Vantage Analyst
Release Number
1.1
Published
December 2019
Language
English (United States)
Last Update
2020-08-06
dita:mapPath
ezh1551894635141.ditamap
dita:ditavalPath
wsp1565965728073.ditaval
Queries from the Model workflow can be saved to database tables for reuse later by Model or elsewhere, such as in a Customer 360 workflow. Use the stored_model_queries and model_sql_statements tables.
  1. Click CREATE MODEL QUERIES.
  2. Enter the Model Name.
  3. Enter a Prefix.
  4. [Optional] To copy the code from the window, scroll down till you see the COPY button.
  5. Click CREATE.
  6. To see the results, use this database query:
    select *
    from stored_model_queries Q
       ,model_sql_statements S
    where Q.id = S.model_id
    ;