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.
- Click CREATE MODEL QUERIES.
- Enter the Model Name.
- Enter a Prefix.
- [Optional] To copy the code from the window, scroll down till you see the COPY button.
- Click CREATE.
-
To see the results, use this database query:
select * from stored_model_queries Q ,model_sql_statements S where Q.id = S.model_id ;