I was changing some config in target-bigquery (tra...
# troubleshooting
a
I was changing some config in target-bigquery (transferwise variant) and this schema definition which used to work is not working anymore. Can someone please help me out with what might have gone wrong or what should be the correct schema?
Copy code
ValueError: {'creditlimit': 0, 'investment': 800000, 'miscellaneous': 0, 'minimumguarantee': 0} (type <class 'dict'>) do not match ['null', {'type': 'record', 'name': 'turingaudio266016.dynamodb.pipelinewise.avro.storefinancials_properties', 'fields': [{'name': 'creditlimit', 'type': ['null', {'logicalType': 'decimal', 'scale': 9, 'precision': 38, 'type': 'bytes'}]}, {'name': 'investment', 'type': ['null', {'logicalType': 'decimal', 'scale': 9, 'precision': 38, 'type': 'bytes'}]}, {'name': 'minimumguarantee', 'type': ['null', {'logicalType': 'decimal', 'scale': 9, 'precision': 38, 'type': 'bytes'}]}, {'name': 'miscellaneous', 'type': ['null', {'logicalType': 'decimal', 'scale': 9, 'precision': 38, 'type': 'bytes'}]}]}] on field storefinancials