Data filters let you transfer a subset of rows instead of copying the full table. Useful for large tables, partial exports, date-bounded loads, or any migration where only a subset of the data is relevant.
A simple filter can pull rows where Date and Permission are grouped by user name:
A compound filter can combine conditions on Permission and a Time column:
Building a filter
On the Customization stage, select a table and click the Filter button.
The Filter window has three panels.
1. New condition
Define one or more conditions. For each condition:
- Pick the table field.
- Pick the operator (not null, equal to, less than, etc.).
- Enter the value.
Click Add condition. Multiple conditions can be combined with AND / OR.
2. Selected conditions
Lists every condition already added.
To delete a condition, select it and click Remove condition.
3. Preview
Shows the resulting query and a sample of returned rows. Click Refresh to apply the current filter.
With Refresh automatically on query change enabled, the preview updates after every edit.
The Query line shows the generated SQL. Editing a condition rebuilds the query automatically.
Notes
You can build a filter from the UI, adjust the generated SQL manually if needed, and rerun the preview to verify the result. Filters keep the migration focused on the rows you actually need - useful for cutting transfer time on large source tables. See Speeding up large transfers for the broader context.