https://linen.dev logo
#plugins-general
Title
# plugins-general
r

ricky_renner

03/16/2021, 9:00 PM
Hey everyone! Anyone had issues running the
target-postgres
target from Transferwise with this error:
Copy code
target-postgres           | time=2021-03-16 20:47:25 name=target_postgres level=INFO message=Table '"machine_rate_full"' does not exist. Creating... CREATE TABLE IF NOT EXISTS excel_source_files_meltano."machine_rate_full" ("" character varying, "_sdc_batched_at" timestamp without time zone, "_sdc_deleted_at" character varying, "_sdc_extracted_at" timestamp without time zone, "_smart_source_bucket" character varying, "_smart_source_file" character varying, "_smart_source_lineno" numeric, "fromdate" character varying, "machine_hour_rate" double precision, "press_number" character varying, "todate" character varying, PRIMARY KEY ("press_number", "fromdate"))
target-postgres           | Traceback (most recent call last):
target-postgres           |   File "/project/.meltano/loaders/target-postgres/venv/bin/target-postgres", line 8, in <module>
target-postgres           |     sys.exit(main())
target-postgres           |   File "/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/__init__.py", line 373, in main
target-postgres           |     persist_lines(config, singer_messages)
target-postgres           |   File "/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/__init__.py", line 219, in persist_lines
target-postgres           |     stream_to_sync[stream].sync_table()
target-postgres           |   File "/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/db_sync.py", line 589, in sync_table
target-postgres           |     self.query(query)
target-postgres           |   File "/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/target_postgres/db_sync.py", line 313, in query
target-postgres           |     params
target-postgres           |   File "/project/.meltano/loaders/target-postgres/venv/lib/python3.6/site-packages/psycopg2/extras.py", line 143, in execute
target-postgres           |     return super(DictCursor, self).execute(query, vars)
target-postgres           | psycopg2.errors.SyntaxError: zero-length delimited identifier at or near """"
target-postgres           | LINE 1: ...S excel_source_files_meltano."machine_rate_full" ("" charact...
target-postgres           |                                                              ^
target-postgres           |
Looks like it is detecting an empty column at the beginning of my Excel file that I am pulling over from
tap-spreadsheets-anywhere
, but the Excel file does not have any empty spaces in the column header row.
2 Views