After you create a connection to a database, you can open a view in the studio to see actual data in the database.
Prerequisite(s): At least one database connection has been created in the Profiling perspective of the studio. For further information, see Connecting to a database.
To display a preview of actual data of a given database table, do the following:
In the DQ Repository tree view, expand Metadata > DB Connections.
Browse to a table in a given database connection, right-click it and select Preview.
The SQL editor opens in the studio listing the data in the selected table.
If required, do any modifications in the query and save it.
The query is listed under the Libraries > Source Files folder in the DQ Repository tree view.