jakob_vestergaard_offersen
10/10/2023, 1:09 PMtap-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
{
"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