# Preview

The preview panel allows previewing the data (max 200 rows), sorting by column, and performing filters.

Once a Transformation has been successfully built, the data is stored in a `.parquet` file and can be efficiently queried and previewed.

By clicking on the details button next to the column names, a statistics panel will open up, giving an overview and some metadata about said column, such as:

* Distinct Count
* Null Count
* Min/Max values

<figure><picture><source srcset="https://1439274090-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZPOu0da4Z2EpltdJNcki%2Fuploads%2FKYntpUL48C6pkH1Febva%2Fdata_statistics_dark.png?alt=media&#x26;token=67d597d2-d700-46e1-9f74-d78fbf541ba4" media="(prefers-color-scheme: dark)"><img src="https://1439274090-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZPOu0da4Z2EpltdJNcki%2Fuploads%2Fj2ZHBQ96FUd4GT978I3b%2Fdata_statistics_light.png?alt=media&#x26;token=2452f83e-5d95-4c69-88b3-ac87ffbb03c0" alt="Data Preview Statistics"></picture><figcaption></figcaption></figure>

The panel also shows a breakdown of unique values and their frequency and gives the possibility to search by value.

### Custom Filter

The filter input at the top of the preview panel allows SQL-style `WHERE` clause to be applied.

Following is an example filter:

```
"Airline" = 'Air France' AND "To" = 'JFK'
```

### Data Extract

The generated dataset can be extracted as a CSV or Parquet file using the export buttons at the bottom of the table.

{% hint style="info" %}
Please note that the [EXPORTER](file:///5959076/user-roles.md#exporter) role is required to be able to extract data
{% endhint %}