I'm using tap-spreadsheets-anywhere and target-postgres (datamill-co) I'm hitting an ValidationError with some data:

ValidationError: "'6030-' is not of type 'null', 'number'

Is it possible to tell tap-spreadsheets-anywhere and/or target-postgres to just treat everything as a varchar so I can deal with the data types once the data is already in postgres?

Have you tried to properly set data type in the spreadsheet itself?

My "spreadsheet" is a csv file, so that's not an option for me.

I keep running into issues like this, and have resorted to using

prefer_schema_as_string: true

But I see there is also an option for specific

schema_overrides:

key. https://github.com/ets/tap-spreadsheets-anywhere

I had apparently looked right past the

prefer_schema_as_string

setting!