I'm attempting tap-square target-duckdb and I'm ge...
# troubleshootingc
Casey G
11/07/2024, 7:17 PMI'm attempting tap-square target-duckdb and I'm getting a loader exception "Exception: key_properties field is required". Can anyone point me in the right direction of what I'm missing? Thanks!
e
Edgar Ramírez (Arch.dev)
11/07/2024, 7:28 PMYou might need
meltano config target-duckdb set primary_key_required falsefalse🙌 1
c
Casey G
11/07/2024, 7:33 PMyes thank you! I think this is an issue because the extractor isn't returning anything so now I'm trying to figure out whats wrong on the tap-square side
e
Edgar Ramírez (Arch.dev)
11/07/2024, 7:34 PMdoes
meltano config tap-square testc
Casey G
11/07/2024, 7:36 PMit does
Copy code
Plugin configuration is invalid
KeyError: 'refresh_token'Casey G
11/07/2024, 7:44 PMmaybe I need to try the singer-io variant
👍 1
Casey G
11/07/2024, 10:16 PMalright, went back to the hotgluexyz tap-square variant. The issue still persists in target-duckdb--jwills related to a particular square table that does not have an 'id' key only a 'catalog_object_id' key.
Copy code
Cannot find ['id'] primary key(s) in record: {'catalog_object_id'...Casey G
11/07/2024, 10:17 PMconfig is set as follows
Copy code
loaders:
- name: target-duckdb
variant: jwills
pip_url: target-duckdb~=0.6
config:
primary_key_required: falseCasey G
11/07/2024, 10:19 PMnot sure if there is a way to alias 'catalog_object_id' to 'id' to overcome this table load or skip this table all together
Casey G
11/07/2024, 10:29 PModd though because tap-square is setting a primary id https://gitlab.com/hotglue/tap-square/-/blob/main/tap_square/streams.py?ref_type=heads#L408
5 Views