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.