Contents

exec:
  max_threads: 1
  min_output_tasks: 1
in:
  type: file
  path_prefix: "..path../customer.csv"
  parser:
    charset: UTF-8
    type: csv
    delimiter: ','
    quote: '"'
    header_line: true
    columns:
     - { name: id, type: long }
     - { name: customer_name, type: string }
     - { name: address, type: string }
     - { name: email, type: string }
     - { name: car_name, type: string }
     - { name: company, type: string }
filters:
  - type: postgress_lookup
    host: localhost
    port: 5432
    database: test
    username: postgres
    password: 1234
    schema: public
    table_name: car
    mapping_from:
      - car_name
      - company
    mapping_to:
      - model
      - brand
    new_columns:
      - { name: car_id, type: string }
      - { name: category, type: string }
      - { name: fuel_capacity, type: string }
out:
  type: file
  path_prefix: "..path../output.csv"
  file_ext: csv
  formatter:
    type: csv
    delimiter: ","
    newline: CRLF
    newline_in_field: LF
    charset: UTF-8
    quote_policy: MINIMAL
    quote: '"'
    escape: "\\"
    null_string: "\\N"
    default_timezone: 'UTC'

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
embulk-filter-postgres_lookup-0.1.7	example/postgres-filter-lookup_testing_csv.yml.liquid