Import the data from Cloud Storage into BigQuery. Create a new BigQuery table, and skip the rows with errors.

Create a Compute Engine instance and create a new copy of the data in Cloud Storage. Skip the rows with errors.

Create a Dataflow workflow that reads the data from Cloud Storage, checks for values outside the expected range, sets the value to an appropriate default, and writes the updated records to a new dataset in Cloud Storage.

Create a Dataflow workflow that reads the data from Cloud Storage, checks for values outside the expected range, sets the value to an appropriate default, and writes the updated records to the same dataset in Cloud Storage.