Thank you for the directions, Kindly excuse me if don't answer straight to your questions as I am very new to Meltano.
I am using transferwise/pipelinewise/singer variant.
I configured it as per the official documentation mention in the page
https://meltano.com/plugins/extractors/mysql.html#installation-and-configuration
I used the Web-UI to configure this extractor, and when I tried to use "test connection", I get the error "Invalid Extractor Connection - Tap mysql"
Sorry, I am just configuring and saving MySQL extractor in the web-ui and hence I don't know how to use the --log-level=debug.
Meltano Version : 1.86
meltano.yml
version: 1
send_anonymous_usage_stats: false
project_id: 87ff3119-edf5-4cb3-8930-1be88595d656
plugins:
extractors:
- name: tap-mysql
variant: transferwise
pip_url: pipelinewise-tap-mysql
config:
host:
ec2-52-16-221-134.eu-west-1.compute.amazonaws.com
port: 3306
user: root
password:
database: adventureworks
loaders:
- name: target-snowflake
variant: transferwise
pip_url: pipelinewise-target-snowflake
config:
account: datalytyx.eu-west-1
dbname: ALIDA
default_target_schema: $MELTANO_EXTRACT__LOAD_DATA
file_format: ' ALIDA_BOM'
user: tf-snow
warehouse: ALIDA_WAREHOUSE
schedules:
- name: mysql-to-snowflake
extractor: tap-mysql
loader: target-snowflake
transform: skip
interval: '@once'
start_date: 2021-10-29 08
3917.981342