mert_bakir
09/18/2023, 11:08 AMid 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
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?edgar_ramirez_mondragon
09/18/2023, 3:45 PMextractors:
- 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.