connection type missing in airflow

preview_player
Показать описание
connection type missing? make sure you've installed the corresponding airflow provider package.
To install the airflow provider package see the following steps.
2. In the search bar search the connection type/provider/service you want to install
3. in our case type "MYSQL" and it will show MySQL click on that
4. once you click it will show the pip command pip install apache-airflow-providers-mysql==3.2.1
5. copy that pip command and install it on the webserver
6. before installing it stops the Airflow webserver and airflow scheduler
7. if you get the mysql_config not found an error or
pip install Mysql-python fails with EnvironmentError: mysql_config not found
use the following command to solve the issue

apache airflow tutorial for beginners

It seems mysql_config is missing on your system or the installer could not find it. Be sure mysql_config is really installed.

For example on Debian/Ubuntu you must install the package:

sudo apt-get install libmysqlclient-dev

Maybe the mysql_config is not in your path, it will be the case when you compile by yourself the mysql suite.

Update: For recent versions of debian/ubuntu (as of 2018) it is

sudo apt install default-libmysqlclient-dev

#airflow #airflowsystem #airflowtutorial

Share, Support, Subscribe!!!
Рекомендации по теме
Комментарии
Автор

i want to use connection type `S3` which is not available

AnkitYadav-rfuu
Автор

Hello, I am trying to connect to Postgres. I have psycopg2-binary installed which is also recommended in airflow providers. But I still cannot see ‘Postgres’ option in ‘Conn Type’. Can you tell me how can I configure using config file or environment variables?

kiranchavadi
Автор

Want to connect with Oracle database, but not able to do it. Please help, if possible.

devashishrokshit
Автор

How will it work for aws managed airflow

devrajpatel
Автор

Hi, in my Airflow installation (v2.5.1), I am not able to find connection type S3. Where to find the Airflow Providers for S3. Thanks

prashantsrivastava
Автор

Hi, In my case dbt cloud is not showing eventhough i have installed pip install . Please help me

anupampandey
Автор

Hello
Even after installing providers package.
Connection is not showing in conn types.
Can you help me?

mohitharyani
Автор

Hello Thanks, Can you please upload a video, how to create a ssh connection type which is a aws ec2 instance

tkumardalai