append - How can I append only a specific subset of a source table?

You can use the `where` subparameter within the `source` parameter. This allows you to provide a `where-expression` to filter the rows from the source table before they are appended to the target table.