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.
-
On the Metadata Insights home
page, click .
-
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.
-
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.
-
Click Preview.
A preview of the data fetched from the constituent physical and logical
models is displayed.