plugins: extractors: - name: tap-mysql var...
# getting-started
j
plugins: extractors: - name: tap-mysql variant: transferwise pip_url: git+https://github.com/transferwise/pipelinewise.git#subdirectory=singer-connectors/tap-mysql config: host: $MYSQL_HOST port: $MYSQL_PORT user: $MYSQL_USER password: $MYSQL_PASSWORD database: $MYSQL_DATABASE use_gtid: true filter_dbs: $MYSQL_DATABASE how can I configure so the tap just get the selected database and selected tables that I want to extract
1
r
Copy code
meltano select tap-mysql --list --all
meltano select tap-mysql <table>
j
so I can do something like config: host: $MYSQL_HOST port: $MYSQL_PORT user: $MYSQL_USER password: $MYSQL_PASSWORD database: $MYSQL_DATABASE use_gtid: true filter_dbs: $MYSQL_DATABASE select: - my_data_base-table_x.* - my_data_base-table_y.*
r
Yep, provided that is the format you see in
Copy code
meltano select tap-mysql --list --all
1