BQ has a data type called BIGNUMERIC that can handle a scale of 38 decimal digits
https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types#decimal_types