Export Airflow connections

export_airflow_connection.py

#!/usr/bin/env python3

"""Export Apache Airflow connections

Run under `airflow` user (or another user owns an `airflow` DB) inside its home directory. Like a:

    [dm-logv@airflow ~]$ sudo -u airflow /bin/bash
    [airflow@airflow dm-logv]$ cd ~
    [airflow@airflow ~]$ chmod +x export_airflow_connections.py 
    [airflow@airflow ~]$ ./export_airflow_connections.py > secrets.py
"""

# Disable Airflow logging
from logging import getLogger, CRITICAL
getLogger('airflow').setLevel(CRITICAL)  

from airflow import settings
from airflow.models import Connection


fields = 'conn_id conn_type host port schema login password extra'.split()

session = settings.Session()
for conn in session.query(Connection).order_by(Connection.conn_id):
    d = {field: getattr(conn, field) for field in fields}
    print(conn.conn_id, '=', d)