Hi everyone .. I started using tap-mysql and melta...
# getting-started
b
Hi everyone .. I started using tap-mysql and meltano to extract data and load it into an s3 bucket. My issue is that I want to configure it to read specific tables and exclude some .. not able to see a clear documentation/samples for that .. it only reads all the tables in the db.
v
I think the getting started tutorial goes over this. Here's the reference docs https://docs.meltano.com/reference/command-line-interface#select Here's where this gets reviewed in the getting started tutorial https://docs.meltano.com/getting-started/part1#select-entities-and-attributes-to-extract Hope that helps if you have questions let us know!
l
I can share a dummy example for postgresql, but it would be the same for mysql
Copy code
- name: warehouse-users-source
    inherit_from: tap-postgres
    variant: meltanolabs
    pip_url: git+<https://github.com/MeltanoLabs/tap-postgres.git>
    select:
    - warehouse-users.*
    metadata:
      warehouse-users:
        replication-method: INCREMENTAL
        replication-key: id
that selects the table <schema>-<table>, and also configures the replication method for the same table.
b
Thanks @luis_vicente Will try it with tap-mysql 🤞