monika_rajput
07/26/2021, 7:17 PM*ubuntu@ip*:*~/projects/*$ meltano schedule run adwords-ad-performance-report
meltano | Running extract & load...
meltano | No state was found, complete import.
target-redshift--adwords | time=2021-07-26 191408 name=target_redshift level=INFO message=Getting catalog objects from table cache...
tap-adwords-ad_performance_report | INFO Syncing customer ID 7567846915 ...
tap-adwords-ad_performance_report | INFO Skipping stream campaigns.
tap-adwords-ad_performance_report | INFO Skipping stream ad_groups.
tap-adwords-ad_performance_report | INFO Skipping stream ads.
tap-adwords-ad_performance_report | INFO Skipping stream accounts.
tap-adwords-ad_performance_report | INFO Skipping stream KEYWORDS_PERFORMANCE_REPORT.
tap-adwords-ad_performance_report | INFO Syncing stream AD_PERFORMANCE_REPORT ...
tap-adwords-ad_performance_report | INFO Loading schema for AD_PERFORMANCE_REPORT
tap-adwords-ad_performance_report | INFO Request made: Service: "ReportDefinitionService" Method: "getReportFields" URL: "https://adwords.google.com/api/adwords/cm/v201809/ReportDefinitionService"
tap-adwords-ad_performance_report | INFO AD_PERFORMANCE_REPORT primary keys are []
target-redshift--adwords | time=2021-07-26 191408 name=target_redshift level=CRITICAL message=Primary key is set to mandatory but not defined in the [AD_PERFORMANCE_REPORT] stream
target-redshift--adwords | Traceback (most recent call last):
target-redshift--adwords | File "/home/.eltano/loaders/target-redshift--adwords/venv/bin/target-redshift", line 8, in <module>
target-redshift--adwords | sys.exit(main())
target-redshift--adwords | File "/home/ubuntu/.meltano/loaders/target-redshift--adwords/venv/lib/python3.8/site-packages/target_redshift/__init__.py", line 447, in main
target-redshift--adwords | persist_lines(config, singer_messages, table_cache)
target-redshift--adwords | File "/home.meltano/loaders/target-redshift--adwords/venv/lib/python3.8/site-packages/target_redshift/__init__.py", line 232, in persist_lines
target-redshift--adwords | raise Exception("key_properties field is required")
target-redshift--adwords | Exception: key_properties field is required
tap-adwords-ad_performance_report | INFO Request made: Service: "ReportDefinitionService" Method: "getReportFields" URL: "https://adwords.google.com/api/adwords/cm/v201809/ReportDefinitionService"
meltano | Loading failed (1): Exception: key_properties field is required
meltano | ELT could not be completed: Loader failed
ELT could not be completed: Loader failed
*ubuntu@ip-172-31-36-52*:*~/rm-projects/meltano-projects/*
edward_smith
07/26/2021, 9:58 PMprimary_key_required
setting for [target redshift](https://github.com/transferwise/pipelinewise-target-redshift), I think you'll find the cause of this error.