I did this setup after reading this blogpost of Willem. I can't thank him enough for this wonderful blogpost.
Under the workspace root folder I created airflow_local which I set as AIRFLOW_HOME. The structure of this directory looks as follows
config- In this directory, I kept thevariables.json,secrets.json(which is again variables but these are secrets) andconnections.jsonlogs- Logs directory