ExternalMatch

Filter ExternalMatch

Overview

Discards records which fields matches values read from a CSV, which is possibly periodically refreshed. CSV files can be compressed (gz or zstd) or not.

Configuration

Keys available in the [filter.config] section:

Name Type Default Required Description
Region string “us-west-2” false AWS region to pass to S3 client (only for files with s3:// prefix)
Files array of strings [] true URL(s) of CSV file(s) containing the strings to match (s3[n]:// or file://). If %s is present, it’s replaced, at download time, with the result of calling time.Now().Format(DateTimeLayout).
DateTimeLayout string "" false Go date time string layout replacing %s in Files, evaluated just before downloading Files. See https://pkg.go.dev/time#Time.Format
TimeSubtract duration false Duration to subtract from time.Now() when evaluating DateTimeLayout. See https://pkg.go.dev/time#ParseDuration
RefreshEvery duration false Period at which Files are refreshed (downloaded again), if not set, Files are never refreshed
CSVColumn int 0 false 0-based index of the CSV column containing the values to consider
FieldName string "" true Name of the record field to consider for the match
KeepOnMatch bool false false If true, keep records if field at FieldName matches any of the CSV values. If false, discard records if field matches any of the CSV values.
Last modified December 12, 2022