Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Creating Data Extraction Filters in the AWS Schema Conversion Tool

Before you extract your data with the AWS Schema Conversion Tool (AWS SCT), you can set up filters that reduce the amount of data that you extract. You can create data extraction filters by using where clauses to reduce the data that you extract. For example, you can write a where clause that selects data from a single table.

Creating Data Extraction Filters

You can create data extraction filters and save the filters as part of your project. With your project open, use the following procedure to create data extraction filters.

To create data extraction filters

  1. On the Settings menu, choose Mapping Rules. The Mapping Rules dialog box appears. The top pane contains transformation rules, and the bottom pane contains filtering rules.

  2. In the Filtering Rules pane, choose Add new rule.

  3. Configure your filter.

    1. For Name, type a name for your filter.

    2. For Where schema name like, type a filter to apply to schemas. The where clause is evaluated by using a like clause. You can enter an exact name to select one schema, or you can enter a pattern to select multiple schemas.

    3. For table name like, type a filter to apply to tables. The where clause is evaluated by using a like clause. You can enter an exact name to select one table, or you can enter a pattern to select multiple tables.

    4. For Where clause, type a where clause to filter data.

  4. After you have configured your filter, choose Save to save your filter. You can also choose Cancel to cancel your changes.

  5. After you are done adding, editing, and deleting filters, choose Save All to save all your changes.

  6. Choose Close to close the Mapping Rules dialog box.

You can use the toggle icon to turn off a filter without deleting it. You can use the copy icon to duplicate an existing filter. You can use the delete icon to delete an existing filter. To save any changes you make to your filters, choose Save All.