You can use a regular expression specify the columns that you want to parameterize in a mass ingestion specification. Use a regular expression when the columns in different source tables have varying names but contain the same information. If you choose to replace columns, you also use a regular expression to specify the pattern in the replace criteria.

For example, you might want to drop the columns that contain Social Security numbers. All of the column names contain

SSN

, but the column names have different prefixes depending on the source table where a column appears. To specify all variations in the column names, you can use a regular expression such as

.*SSN

.