Hello everyone ! I am trying to design a pipeline...
# getting-started
a
Hello everyone ! I am trying to design a pipeline to extract data from MySQL and load it into Snowflake. I get the error - "Invalid Extractor Connection - Tap mysql" PS : I could connect to the MySQL host using mysql-client from the Meltano host using the same credentials and telnet works too. Tried the setup in both Ubuntu 20.04 and CentOS 7 - Same error 😞 Can I get some help to resolve this please
t
Re-posting my comment since this is now a public channel. Which specific variant are you trying to run? We recommend you also run with 
--log-level=debug
 and share the command plus some of the stack trace.
a
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 083917.981342