Determining the data type #57502
Unanswered
Michal6040
asked this question in
Platform General Questions
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
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?
Beta Was this translation helpful? Give feedback.
All reactions