All rows of data are transferred from a data source table to Ingest Instance storage unless you add a row filter rule that matches the table.

Adding a Row Filter Rule

The rule defines the criteria a row needs to have to be included, e.g. an ID over a specific number or a timestamp later than a specific date.

To filter out rows of data from transfers, follow the steps below.

1. Open the relevant Ingest Instance instance. Right-click the data source and click Filter Rows…

   

2. Click Add... to add a new rule.
3. If you want the rule to apply to specific tables, enter the schema and/or table names that they need to match. In the Schema/Table list, click on the operator you want to use and type text to match in the box.
4. Click Add to add a new column and value combination. In the Column list, click on the operator you want to use and type the text to match in the box. In the Value list, click on the comparison you want to use and enter a value in the box.
5. Click OK to add the rule. 

   

6. (Optional) In the Filter Rows window, click Refresh to see a list of affected tables. Click Preview to open the query tool with a preset query to see what rows will be transferred from a specific table.