Save Model Query/Selected Results | Vantage Analyst - 1.1 - Saving a Model Query or Selected Results - Vantage Analyst

Vantage Analyst User Guide

prodname
Teradata Analytic Apps
Vantage Analyst
vrm_release
1.1
category
User Guide
featnum
B035-3805-099K
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
    ;