https://linen.dev logo
#plugins-general
Title
# plugins-general
j

jakob_vestergaard_offersen

10/10/2023, 1:09 PM
Hey all, 👋 Im running into an issue with the
tap-csv
--discover
capability: Question: How to I configure the tap to correctly infer more than strings using the discover capability? Context: The types of the csv columns are inferred to all be
["string", "null"]
which doesnt match the csv Im extracting. When running
meltano invoke tap-csv --config ./config.json --discover > ./output.json
where
config.json
is
Copy code
{
  "files": [
    {
      "entity": "some_entity",
      "path": "./test.csv"
    }
  ]
}
and
test.csv
is
ID,FirstName,Email,Nationality,DateOfBirth,IsMarried,Height,Weight,Address
1,John,<mailto:johndoe@example.com|johndoe@example.com>,American,1990-05-15,true,175.5,68.2,123 Main St
2,Jane,<mailto:janesmith@example.com|janesmith@example.com>,Canadian,1985-09-22,false,163.8,55.7,456 Elm St
3,Michael,<mailto:michaeljohnson@example.com|michaeljohnson@example.com>,British,1992-02-10,true,180.0,72.1,789 Oak Ave
4,Sarah,<mailto:sarahwilliams@example.com|sarahwilliams@example.com>,Australian,1988-11-30,true,155.2,48.9,321 Pine St
Thanks in advance for your expertise! Regards, Jakob