Apache Airflow unable to connect to RDS mysql database

I am trying to play around with some data in the Ad Hoc Query sandbox in the Airflow UI. I have saved the credentials under the Admin>Connections however I was not able to connect to my database in RDS. What I am doing wrong?

configuration of database on UI

I check my Ad Hoc Query terminal and my analytics_mysql database is not present. the database I want to query, analytics_mysql, is not present

After installing the mysql package from Airflow, I got this error

mysql package error

Any help would be greatly appreciated!

1 answer

  • answered 2018-01-12 01:34 Jean-Christophe Rodrigue

    I am not sure you did this but you need to install the right packages for mysql

    pip install apache-airflow[mysql]

    See airflow installation instructions for the complete details