Previewing Data

You can preview data at table level using SQL queries. Data previewing capability at table level enables you to view data instantly and profile the data. You can also schedule a data profiling job and view data profiling summary report at the scheduled time.

Data Quality tab is not available if the Enable DQ Sync option is enabled for environments.

To preview table data, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. On the Explore tab, click an environment tile to see its details.
  3. In the Data Catalog pane, click a table.
  4. Click the Data Quality tab.

    5. By default, the Data Profiling tab opens.

  5. Click the Preview Data tab.

    6. The User Credentials page appears. For more information on enforcement of user credentials, refer to the Enforcing Credentials for Data Access or Preview topic.

  6. Enter credentials to connect with the database.

    7. Data at table level can be viewed. You can use SQL Editor to execute a SQL query to preview data.

You can also profile data at table level and provide data quality score.