exec:
  max_threads: 2
  min_output_tasks: 1
in:
  type: file
  path_prefix: C:\Users\Abhishek Gupta\Desktop\github\embulk-filter-postgres_lookup\calendar.csv
  parser:
    type: csv
    columns:
      - { name: dim_calendar_key, type: long }
      - { name: year_number, type: long }
      - { name: quarter_number, type: long }
      - { name: attr_1, type: string }
filters:
  - type: postgress_lookup
    driver_path: C:/Users/Abhishek Gupta/Desktop/postgresql-9.0-801.jdbc4.jar
    driver_class: org.postgresql.Driver
    schema_name: testSchema
    host: localhost
    port: 5432
    database: Abhishek
    table: country
    username: postgres
    password: root
    mapping_from:
      - quarter_number
      - attr_1
    mapping_to:
      - id
      - country_address
    new_columns:
      - { name: country_name, type: string }
      - { name: country_address, type: string }
out:
  type: file
  path_prefix: C:\Users\Abhishek Gupta\Desktop\B\output.csv
  file_ext: csv
  formatter:
      type: csv
      delimiter: "\t"
      newline: CRLF
      newline_in_field: LF
      charset: UTF-8
      quote_policy: MINIMAL
      quote: '"'
      escape: "\\"
      null_string: "\\N"
      default_timezone: 'UTC'