ananya
08/01/2022, 5:40 PMRedshift
but unfortunately running into error, more details in the thread.
Any help would be appreciated! 🙂ananya
08/01/2022, 5:40 PMananya
08/01/2022, 5:40 PMprimary_keys = None
/ primary_keys = []
in the defined stream but still giving the same error.edgar_ramirez_mondragon
08/01/2022, 5:42 PMedgar_ramirez_mondragon
08/01/2022, 5:43 PMdbname
in the target configananya
08/01/2022, 5:44 PMdbname
responsible for the error.ananya
08/01/2022, 5:47 PMedgar_ramirez_mondragon
08/01/2022, 5:51 PM2022-08-01T17:15:42.497619Z [info ] * Required key is missing from config: [dbname] cmd_type=loader job_id=greenhouse-to-redshift name=target-redshift run_id=03f08b22-98ac-477a-a3dc-df983d9458a3 stdio=stderr
This message actually says the configuration is invalid:
2022-08-01T17:15:42.497501Z [info ] time=2022-08-01 22:45:42 name=target_redshift level=ERROR message=Invalid configuration: cmd_type=loader job_id=greenhouse-to-redshift name=target-redshift run_id=03f08b22-98ac-477a-a3dc-df983d9458a3 stdio=stderr
Can you confirm that you’re setting dbname
? You can use meltano config target-redshift list
ananya
08/01/2022, 5:55 PMdbname
is not none.ananya
08/01/2022, 6:05 PMprimary key
basically this one was my original error.
😟
error:
2022-08-01T17:54:55.443843Z [info ] return super(DictCursor, self).execute(query, vars) cmd_type=loader job_id=greenhouse-to-redshift name=target-redshift run_id=751eb7f9-b34a-425b-8387-407048c68824 stdio=stderr
2022-08-01T17:54:55.443963Z [info ] psycopg2.errors.UndefinedColumn: column "i" named in key does not exist cmd_type=loader job_id=greenhouse-to-redshift name=target-redshift run_id=751eb7f9-b34a-425b-8387-407048c68824 stdio=stderr
2022-08-01T17:54:55.444076Z [info ] cmd_type=loader job_id=greenhouse-to-redshift name=target-redshift run_id=751eb7f9-b34a-425b-8387-407048c68824 stdio=stderr
2022-08-01T17:54:55.493055Z [debug ] Deleted configuration at /Users/ananyasingh/Code/Remote/etl/.meltano/run/elt/greenhouse-to-redshift/751eb7f9-b34a-425b-8387-407048c68824/target.aab7e180-99da-473b-99f7-f480e57fa5d0.config.json
2022-08-01T17:54:55.493533Z [debug ] Deleted configuration at /Users/ananyasingh/Code/Remote/etl/.meltano/run/elt/greenhouse-to-redshift/751eb7f9-b34a-425b-8387-407048c68824/tap.2cfa280f-188a-4f21-8c4d-3a60252d45b2.config.json
2022-08-01T17:54:55.493634Z [error ] Loading failed code=1 job_id=greenhouse-to-redshift message=(see above) name=meltano run_id=751eb7f9-b34a-425b-8387-407048c68824
2022-08-01T17:54:55.496981Z [debug ] ELT could not be completed: Loader failed
ananya
08/01/2022, 6:21 PMprimary_keys = []
and in meltano.yml file
- name: tap-greenhouse
namespace: tap_greenhouse
pip_url: -e extract/tap-greenhouse
executable: tap-greenhouse
capabilities:
- state
- catalog
- discover
settings:
- name: api_key
- name: start_date
metadata:
activityfeed:
key_properties: null
I think I am doing something wrong here as am still a noob here.. 😅edgar_ramirez_mondragon
08/02/2022, 12:15 AMananya
08/02/2022, 1:52 AMananya
08/02/2022, 6:03 PMedgar_ramirez_mondragon
08/02/2022, 7:03 PM@ananya I’m not sure where columncolumn "i" named in key does not exist
i
might be coming from 🤔