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.