Hey there! I try to run a pipeline using tap-csv a...
# troubleshooting
p
Hey there! I try to run a pipeline using tap-csv and target-postgres (local). But I get this error: • singer_sdk.exceptions.MissingKeyPropertiesError: Record is missing one or more key_properties • Key Properties: ['id', 'firtsname', 'lastname', 'email', 'phone', 'profession'], Record Keys: ['id', 'firstname', 'lastname', 'email', 'phone', 'profession'] This is my meltano.yml setup:
Copy code
plugins:
  extractors:
  - name: tap-csv
    variant: meltanolabs
    pip_url: git+<https://github.com/MeltanoLabs/tap-csv.git>
    config:
      csv_files_definition: files_def.json
  loaders:
  - name: target-csv
    variant: hotgluexyz
    pip_url: git+<https://github.com/hotgluexyz/target-csv.git>
    config:
      destination_path: ''
  - name: target-postgres
    variant: meltanolabs
    pip_url: meltanolabs-target-postgres
    config:
      database: meltano
      port: 5432
      user: postgres
      host: localhost
      default_target_schema: Users
      activate_version: false
      add_record_metadata: false
And this my files_def.json:
Copy code
[{    
      "entity": "Users",
      "path": "./CSV-Template1.csv",
      "keys": [ "id",
      "firtsname",
      "lastname",
      "email",
      "phone",
      "profession"]
}]
I appreciate if somebody know what is the problem or what I missing
r
firtsname
!=
firstname
?
1