Query: What is the difference between the NUMERIC and FLOAT data types in BigQuery?
Context: The NUMERIC data type in BigQuery is used for precise fixed-point arithmetic, suitable for financial calculations where exactness is crucial. It supports up to 38 decimal digits of precision. In contrast, the FLOAT data type is a floating-point number that provides approximate numeric storage and is used for scientific calculations where precision can be sacrificed for a larger range of values.