Sampling output

Most transformation components and query components give you the ability to sample the data output by that component.

Sampling allows you to see the data the component is working with, and to confirm that the component is set up correctly before using it in a live pipeline.

Prerequisites

Before you can sample a component's output, you must first validate the pipeline. Read The pipeline canvas for more information.

---

Sampling data

To sample, select the component on the canvas and click the Sample data tab, then click the Sample data button on that tab. The tab will display a table of data that the component would return when the pipeline runs, up to a maximum of 1000 rows.

Limit sample

The sample limit drop-down menu indicates how many rows will be returned. You can use this menu to limit your sample to as few as 1 row, or as many as 1000 rows, with many options in-between, such as 10, 25, and 250. The default is 25 rows.

Resize columns

To resize the columns of the sample table, hover over a column edge and when you see the resize handle, click and drag it to increase or decrease the column width.

Refresh sample

Click the refresh button at the top of the Sample data tab to see the row count of the current sample.

Note

Alternatively, click the Sample data button in the Properties panel to sample the data for your validated pipeline.