Any recommendations for a `tap-googleads` variant ...
# troubleshootinga
Andy Carter
08/29/2023, 9:31 PMAny recommendations for a The matatika variant specifies primary keys as key within a json object column, which postgres doesn't seem support. my mistake matatika just needs json flattening applied
• Also tried the AutoIDM variant, which creates the necessary PKs as top level json keys to fix the issue above, but then I'm having issues with state duplication errors. (see below in thread)
AutoIDM would work fine with a
tap-googleads--full-refreshAndy Carter
08/29/2023, 9:31 PM Copy code
2023-08-29T21:21:52.653523Z [info ] ValueError: State file contains duplicate entries for partition: {state_partition_context}. cmd_type=elb consumer=False name=tap-googleads producer=True stdio=stderr string_id=tap-googleads
2023-08-29T21:21:52.653678Z [info ] Matching state values were: [{'context': {'resourceNames': ['customers/2705896600', 'customers/2368880772'], 'client_id': '2705896600'}}, {'context': {'resourceNames': ['customers/2705896600', 'customers/2368880772'], 'client_id': '2705896600'}, 'starting_replication_value': None}] cmd_type=elb consumer=False name=tap-googleads producer=True stdio=stderr string_id=tap-googleadsv
visch
08/29/2023, 11:35 PMPlease submit this bug to the tap GitHub repo, it smells like start date isn't set? Try running a full refresh with start date set to something
4 Views