In Foundry, which schema field type requires specifying both precision and scale parameters?

In Foundry, the schema field type that requires specifying both precision and scale parameters is DECIMAL. This data type is utilized for representing fixed-point numbers to ensure accurate representation of fractional values.

Precision refers to the total number of digits that can be stored, while scale defines how many of those digits are to the right of the decimal point. For example, if a DECIMAL type is defined with a precision of 6 and a scale of 2, it can store numbers up to 9999.99, where a total of four digits can be to the left of the decimal and two digits to the right. This specificity allows for high accuracy in financial calculations and other applications where exact decimal representation is crucial, as simply using a floating-point type might lead to rounding errors.

Other options, such as ARRAY, DATE, and STRING, do not require precision and scale parameters. An ARRAY can hold a collection of elements, a DATE handles date values without the need for precision or scale, and a STRING represents a sequence of characters, also not dependent on numerical attributes like precision and scale.