Determining the data type

[Michal6040]

Using open-source Airbyte I'm importing data from an excel file into postgresql and I'm struggling with specifying the data types. I've tried setting up reader options in File (CSV, JSON, Excel, Feather, Parquet) source with {"dtype": {"ID": "integer"}, "na_values": ["N/A", "", "null"], "keep_default_na": false, "infer_schema": false} but this seems to be ignored and the connector infers numeric data type for col "ID". Are there any other options how I could change data types while importing data from excel to postgresql?

[Airbyte Support Bot (airbyte-support-bot)]

Hi! This discussion hasn't had activity in over a year. Is this still relevant to you? If so, please reply and we'll keep it open. If we don't hear back within 14 days, we'll close this as part of our housekeeping. You can always reopen or create a new discussion later. Thanks!

---

Devin session