e2e-data-engineering icon indicating copy to clipboard operation
e2e-data-engineering copied to clipboard

Published 20 hours ago • verified publisher icon airscholar

Exception has occurred: AirflowConfigException

Open Kanangnut opened this issue 1 year ago • 1 comments

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.

Kanangnut avatar Feb 20 '24 11:02 Kanangnut

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 🤗

prikshit-2000 avatar May 05 '24 05:05 prikshit-2000