I have a jsonb column in the source (postgres): `...
# troubleshooting
m
I have a jsonb column in the source (postgres):
Copy code
id options
1 null
2 null
3 [{"label": "Missing Tracking", "value": 1}, {"label": "Wrong label", "value": 4}]
Schema generated by tap-postgres:
"options": {"properties": {}, "type": ["object", "null"]}
target-postgres throws error on validation
Copy code
Failed validating 'type' in schema['properties']['options']: {'properties': {}, 'type': ['object', 'null']}

On instance['options']:
    [{'label': 'Missing Tracking', 'value': 1},
     {'label': 'Wrong label', 'value': 4}]
What should I do?
e
You can probably override that field's schema:
Copy code
extractors:
- name: tap-postgres
  schema:
    some_stream_id:
      options:
        type: ["object", "array", "string", "null"]
The long-term solution is to update the tap to generate a schema like
{"properties": {"my_json_field": {}}}
. I logged https://github.com/MeltanoLabs/tap-postgres/issues/238.