I'm trying to use the schema override that is part of the extras. I'm running into an issue going from a CSV (via spreadsheets-anywhere) to Postgres. The extras work well for strings (though thats the only one I have a good example of). The postgres table is ready to except a year as an integer as that column is set to an integer. The Postgres-target It keeps forcing it to a numeric and ignoring my integer column. It's also ignoring my dates. First off, have I setup these schema extra lines correctly for integers and dates? What are all the different choices I have? I can't seem to find whether I have integers, float, etc.

schema:

accounts:

acct_number:

type: ["null","string"]

gl_transactions:

account:

type: ["null","string"]

future:

type: ["null","string"]

intercompany_segment:

type: ["null","string"]

project:

type: ["null","string"]

effective_year:

type: ["integer"]

effective_date:

type: ["null","string"]

format: date-time

Hi @greg_vaslo the schema types are very target dependent. Assuming your using the pipeline wise variant it's probably easiest to look at the code https://github.com/transferwise/pipelinewise-target-postgres/blob/e060d44c376095a9c8ae1a731f548ab9aa16c2f3/target_postgres/db_sync.py#L40