Previewing a Model Store

To preview a deployed model store, select it from the list of model stores, click Preview, and run the required SQL query. The preview result displays a maximum of 50 records.

Note: An un-deployed model store cannot be previewed.
  1. On the Metadata Insights home page, click Modeling > Model Store.
  2. From the list of model stores displayed, select the model store that you want to preview, and click the Preview icon .
    The Preview Model Store - <name of the model> page is displayed.
  3. In the SQL query textbox, type in the query to retrieve the desired data from the selected model store. Enclose the table name within double-quotes.
    select * from "EMPLOYEE_SALARY";
    Note: If the same table name exists in two different physical models, you need to provide the <physicalmodelname>.table name to run the query successfully.
  4. Click Preview.
    A preview of the data fetched from the constituent physical and logical models is displayed.