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: sqlserver
    host: Localhost
    driver_path: "..path../mssql-jdbc-10.2.0.jre17.jar"
    username: "user"
    password: "password"
    database: "test"
    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

2 entries across 2 versions & 1 rubygems

Version	Path
embulk-filter-mssql_lookup-0.1.5	example/mssql-filter-lookup_testing_csv.yml.liquid
embulk-filter-mssql_lookup-0.1.4	example/mssql-filter-lookup_testing_csv.yml.liquid