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

to validate your data query. Use the

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.