I'm running `tap-bing-ads` and getting an errors `...
# plugins-general
i
I'm running
tap-bing-ads
and getting an errors
Copy code
Primary key is set to mandatory but not defined in the [campaign_performance_report] stream
and
Copy code
key_properties field is required
on campaign_performance_report when trying to load into snowflake. Am I understanding this correctly, that my
target-snowflake
doesn't have instructions on what the primary key should be? If so, how do I give that instruction? I've tried adding this to my tap-bing-ads YAML
Copy code
select:
      - campaign_performance_report.AccountId
      - campaign_performance_report.CampaignId
      - campaign_performance_report.TimePeriod
      - campaign_performance_report.Spend
    metadata:
      campaign_performance_report:
        key-properties: [AccountId,CampaignId,TimePeriod]
but no luck.
I've also tried with
key_properties
(using underscore instead of dash), same result. Same errors.
seems I'm not alone with this problem. There are already comments about this two years back, and a simple pull request, but I guess the plugin has been abandoned https://github.com/singer-io/tap-bing-ads/compare/master...EmaLoprevite:tap-bing-ads:fix-key_property