Sample Rows

Take a random sample of rows

What It Does

Sample Rows pulls a random subset of the dataset. Useful for prototyping a transformation against a slice before running it on the whole file, or for quick exploratory looks at huge datasets. Sample by row count or percentage; with a seed the same rows come back every time.

How to Use It

Opening the Panel

Click the + button in the toolbar or press the operation picker, then search for "Sample Rows". It's in the Filter & Sort group.

Configuration

Field	Type	Required	Description
`Sample by`	Select	Yes	rows (count) or percent
`Sample size`	Number	Yes	Row count or percentage 0 to 100
`Random seed`	Number	No	Optional integer for reproducibility

SQL generated under the hood

SELECT * FROM data USING SAMPLE 1000 ROWS (REPEATABLE 42)

Try this operation →

Related Operations

Filter - Show only rows matching conditions
Limit Rows - Keep only the first N rows
Top / Bottom Rows - Show top or bottom N rows by column value