How to dynamically add all tables in a specific schema?

[Sonja_Bauernfeind]

Tech-Note: FAQ

Question

How to dynamically add all tables in a specific schema?

Answer

Replicate allows the user to include a dynamic table selection. This is done using a pattern as follows:

Schema Pattern Result

HR	%	All tables in the HR Schema. This will include any newly added table.
HR	JOB%	All tables starting with JOB, for example: JOB_HISTORY JOBS
HR	%HISTORY%	All tables starting with JOB, for example: JOB_HISTORY JOB_HISTORY_ACTIVE

After specifying the schema and pattern click on Include

 

After clicking on the pattern, it will be added to the "Table Selection Pattern" with the prefix "Include":