embulk-variable-idea.yml

variables:  # declare variables in a config file
  myval: 1
plugin_variables:  # run an input plugin, and use tha last (or first) row as variables
  type: postgresql
  query: select max(id) as max_id from access
  database: production
  host: pg_analyze
in:
  type: mysql
  query: select id, host, ip from access_source where ${max_id} < id
  database: production
  host: my_tran
out:
  type: postgresql
  table: access
  database: production
  host: pg_analyze