airscholar/e2e-data-engineering

Exception has occurred: AirflowConfigException

Opened this issue · 1 comments

Kanangnut commented

Exception has occurred: AirflowConfigException
Cannot use relative path: sqlite:///C:\Users\User_Win10x64/airflow/airflow.db to connect to sqlite. Please use absolute path such as sqlite:////tmp/airflow.db.
File "D:\Work\data-engineer\dags\kafka-stream.py", line 2, in
from airflow import DAG
airflow.exceptions.AirflowConfigException: Cannot use relative path: sqlite:///C:\Users\User_Win10x64/airflow/airflow.db to connect to sqlite. Please use absolute path such as sqlite:////tmp/airflow.db.

prikshit-2000 commented

I was able to solve this error. just got to the path where the error is coming up from in your case it will be C:\Users\User_Win10x64/airflow/ and change the airflow.cfg sql_alchemy_conn parameter as sql_alchemy_conn=sqlite:////tmp/airflow.db.
Hope it helps 🤗