Hello all if anyone encountered this error before ...
# troubleshooting
m
Hello all if anyone encountered this error before please tell how to fix
*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/*
e
If you look at the
primary_key_required
setting for [target redshift](https://github.com/transferwise/pipelinewise-target-redshift), I think you'll find the cause of this error.