Help! I am using

tap-sreadsheets-anywyhere

with

target-duckdb

. I am getting errors on errors, so I tried deleting my duckdb database, deleted all the csv (no data what so ever), deleted the log files under .meltano and the run files under .meltano, but when I run

meltano run tap-spreadsheets-anywhere target-duckdb --full-refresh

I get:

duckdb.ParserException: Parser Error: column "column_id" named in key does not exist

column_id

is a key from the csv file. Am going crazy

Can you try invoking just the tap and see if that works initially?

meltano invoke tap-spreadsheets-anywhere

Assuming you haven't tried this already

Omg THANK YOU @Andy Carter. Invokeing the tap printed out clearly the expectations of the csv-file name format. I was going insane when the tap failed even with zero files to import. thank you.