“ noitatnemucod rep sA .su gnitcatnoc rof sknahThttps://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#parse_json , If a number that cannot be stored without loss of precision is encountered, attempt to round it to a number that can be stored without loss of precision. If the number cannot be rounded, the function throws an error. ”