Amount and currency match region/account

money_currency_consistency - Column-level - Money

Validates that a currency code column only contains an allowed set of codes.

Parameters

Parameter	Type	Default	Required	Description
currency_column	str	none	No	Optional column holding a currency code, e.g. USD or EUR.
allowed_currencies	list	none	No	Optional list of allowed currency codes.
threshold_percent	float	0.0	No	Fail if the percentage of violations exceeds this.

YAML example

checks:
  - name: example_money_currency_consistency
    check_type: money_currency_consistency
    table_name: schema.table
    column_name: example_column
    parameters:
      threshold_percent: 0.0

See YAML check format for the full field reference.