ricky_renner
03/16/2021, 9:00 PMtarget-postgres
target from Transferwise with this error:
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.