Hello everyone! I try to use a Meltano pipeline wi...
# troubleshooting
p
Hello everyone! I try to use a Meltano pipeline with target-bigquery variant youcruit, this target use fastavro, and when I test the pipeline I have this error: ValueError: Decimal('-417.240000000') (type <class 'decimal.Decimal'>) do not match ['null', 'string'] on field. I tried to parse the value using str but doesn't work. Also when I print to know the type of the value I get that is float, but I get this error so I don't know what is the problem. Someone knows what can I do?
e
You can try overriding the JSON schema type for that field to be numeric:
Copy code
extractors:
- name: my-tap
  schema:
    some_stream_id:
      my_numeric_field:
        type: ["number", "null"]
p
One of the strangest thing is that the schema say that the types for this field are null, number and string. But the target omit the number type