> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Data exploration for Data Engineers

> Inspect interim data samples at each stage of your pipeline

The Data Explorer helps you inspect interim data samples at each stage of your pipeline. By checking column structure, reviewing sample values, and confirming data types, you can catch issues early and ensure your pipeline is working as expected.

## Open the Data Explorer

To use the Data Explorer, you need to [run](/data-engineering/development/runs/execution#interactive-execution) your pipeline to generate data samples. Click on any data sample in your pipeline to open the Data Explorer.

<img src="https://mintcdn.com/prophecy-62973bd0/dljM4e5bzMFf5w3s/data-engineering/development/data-explorer/img/interim-data-samples.png?fit=max&auto=format&n=dljM4e5bzMFf5w3s&q=85&s=1760b665f2b78a7173fcfabf2be74db0" alt="Data sample in a pipeline" width="2866" height="1610" data-path="data-engineering/development/data-explorer/img/interim-data-samples.png" />

## Leverage the Data Explorer

In the Data Explorer, you can:

* Sort data by columns
* Filter rows by specific values
* Search across all values
* Show or hide columns
* Export the sample as CSV or JSON file
* Save the transformation as a new gem

<img src="https://mintcdn.com/prophecy-62973bd0/dljM4e5bzMFf5w3s/data-engineering/development/data-explorer/img/Data_Explorer.png?fit=max&auto=format&n=dljM4e5bzMFf5w3s&q=85&s=5bd38e39b64422033ab4fa2503b53457" alt="Data explorer" width="2620" height="1508" data-path="data-engineering/development/data-explorer/img/Data_Explorer.png" />

## View complete dataset

The Data Explorer loads a sample of your data by default. When you sort, filter, or search, these actions apply only to the visible rows in the sample.

To work with the full dataset, do one of the following:

* Click **Load More** at the bottom of the table until all rows are visible.
* Click **Run** in the top-right corner of the preview. This refreshes the view and applies sorting and filtering to the entire dataset.
