Anyone have an example of a meltano.yml file for u...
# singer-tap-development
f
Anyone have an example of a meltano.yml file for using https://github.com/wintersrd/pipelinewise-tap-mssql#readme? I can get a discover to work, but if I just do a elt from the tap to target-jsonl I get
Exception: only INCREMENTAL and FULL TABLE replication methods are supported
. Not sure where to specify this in the config (in meltano.yml).
e
@fred_reimer I haven't used tap particular tap, but the metadata extra should work:
Copy code
extractors:
- name: tap-msssql
  pip_url: git+<https://github.com/wintersrd/pipelinewise-tap-mssql.git>
  metadata:
    some_stream_id:
      replication-method: INCREMENTAL
      replication-key: created_at
      created_at:
        is-replication-key: true
f
Ah! So I need to do a discover, find out the stream ID's for all the tables, then put in metadata for each one to set the replication method. Thanks!