Filtering Rows in Ingest Instance Data Sources

By default, all rows from a data source table are transferred to Ingest instance storage. To limit the rows that are transferred, add a row filter rule that defines the criteria a row must meet to be included — for example, an ID value above a specific number or a timestamp later than a specific date.

1. Open the relevant Ingest instance. Right-click the data source and select Filter Rows…
2. Click Add… to add a new rule.
3. To apply the rule to specific tables, enter the schema and/or table names the tables must match. In the Schema / Table list, select the comparison operator and enter the text to match.
4. Click Add to add a new column and value condition. In the Column list, select the comparison operator and enter the text to match. In the Value list, select the comparison and enter the value.
5. Click OK to save the rule.
6. (Optional) In the Filter Rows window, click Refresh to see a list of tables affected by the rule. Click Preview to open the query tool with a preset query showing which rows will be transferred from a specific table.