You can use the data builder to create data queries to prepare data for
analytics. You can use a
data query to
subset, sort, join, and add calculated columns to tables.
As you create your data query, click
![the Validate button](images/validateitem.png)
to validate your data query. Use the
![Run](images/play.png)
button to
preview or run the data query.
The preview option uses a
temporary table for the
output table. Clicking the
Results tab shows only the first 100 rows. When you run the data query, it uses the specified
output table instead of a temporary table.