---
schema_version: "1"
id: 0cfd47c5d6cbe166823fc0deef0391d793fc900be36afb942e30f433d01d0e05
title: Preview Results in a Data Prep Recipe
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_preview_results.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_preview_results.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: aee90d8c50a63ed359ffa72b4b62bd6ff31af3854033f1a9896b25d8c54f53b2
description: As a best practice in CRM Analytics, catch mistakes early by previewing the results of each node and transformation that you add to your Data Prep recipe.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Preview Results in a Data Prep Recipe

As a best practice in CRM Analytics, catch mistakes early by previewing the results of each node and transformation that you add to your Data Prep recipe.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d54064e28">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d54064e28 ">To create a recipe:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d54064e28 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>
          </tr>
        </tbody>
      </table>

Watch a demo: [![Play button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/play_btn.png) Preview Recipe Changes to Data (English Only)](https://salesforce.vidyard.com/watch/j51rttEc4T2VvgkVaWrsyG?)

The preview shows a sample of the data—up to 5,000 rows. It shows the latest available data, except when you preview a connected object. When previewing a connected object, the preview can show outdated sample data. The sample data for a connected object updates when you run data sync and the sample data is more than 24 hours old. For example, if the data sync just ran, but your sample data isn’t more than 24 hours old, you don’t see the updated sample data right away.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note The column profile is also based on the sample data. It also doesn’t include changes to the connected object data within the last 24 hours.

1. In the Data Prep recipe, select a node in the graph to view its results.
    
    For example, selecting an aggregate node shows these preview results.
    
    ![The Preview tab shows the results after applying the Aggregate node.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_node_preview.png)
    
    When you add a filter node, the preview filters the currently sampled rows. For example, the recipe processes 20,000 rows. The preview shows 5,000 sample rows for the aggregate node. If you add a filter node after the aggregate node, you might see only 4,000 of the same sampled rows. The preview doesn’t retrieve an updated sample of 5,000 rows for the filter node.
    
    Subsequent nodes, such as joins, filters, and transforms, apply their logic to the sample. This behavior means that the sample set can become empty. For example, if the input sample rows to a join don’t have IDs in common, no sample data shows for the node. Similarly, if a filter’s criteria removes all the sample rows, subsequent nodes also show no sample data.
2. If needed, edit the node to ensure that it produces the correct results.
3. In a transform node, select a transformation step.
    
    For example, selecting a formula transformation that concatenates the billing state and country shows these results.
    
    ![The Preview tab shows the state and country values combined in a new column.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_preview_transformation_results.png)
4. If needed, edit the transformation to ensure that it produces the correct results. When the data preview for a node doesn’t complete immediately, view the preview build status at a glance with the progress wheel. Hover over the wheel to see the percent built.
5. To focus on columns impacted by a node or transformation, you can hide other columns from the preview. Select a column in the Preview tab and click **Hide** (![Hide button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/hideIcon.png)). Hiding a column from preview doesn’t remove it from the recipe.
6. To view the columns only and hide the data, click the Columns tab.
7. To save the recipe, click **Save**.

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_example.png)

Example

To increase performance when previewing results in Data Prep, hide columns that don’t require a preview, such as columns that aren’t transformed by a node or transformation. By default, only the first 100 columns of each source object in an input node show in preview. To hide a column from preview, select it and then click the Hide button in the Transform toolbar.

![The Hide button is in the toolbar of the transform node.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_best_practices_hide_cols.png)

To further increase preview performance, hide all unused columns. Click the Hide Unused button from the Transform toolbar.

![The Hide Unused button is in the toolbar of the transform node.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_best_practices_hide_unused_cols.png)

If data preview is still delayed, disable data preview. You can always turn it back on when you want to see your progress.

![The Data Preview menu is in the toolbar at the top right of the Data Prep graph.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_best_practices_disable_preview.png)

Troubleshooting Recipe Preview Issues

When building or editing a Data Prep recipe in CRM Analytics, the preview can fail to load and show `Error 2006` or the message “Preview timed out.” In this scenario, the recipe editor becomes unresponsive and you can’t validate your transformation logic. This issue can affect users working with large datasets, complex transformation chains, or recipes sourcing data from multiple connections.

For more information on resolving this error, see [CRM Analytics Recipe Preview Timeout and Error 2006: Causes and Resolutions](https://help.salesforce.com/s/articleView?id=005385254&type=1&language=en_US).