ilkka_peltola
06/29/2022, 10:04 AMtap-bing-ads
and getting an errors
Primary key is set to mandatory but not defined in the [campaign_performance_report] stream
and
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
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.