Forum Discussion
dbt-DataWorkFlow setup
Hi,
I have created a dbt project that runs on my fabric data warehouse correctly. So easily I can access my fabric DWH using vs code.
Expectedly, now I need to automate my dbt core project using Data WorkFlow. I tried to use the instructions here (Transform data using dbt - Microsoft Fabric | Microsoft Learn).
But unfortunately after creating the project in Fabric Workflow the DAG Run button on the top of my .py file disappears. In fact I can just run the Workflow Pool but cannot run my DAG.
Meanwhile, there is also some discrepency in the instruction page of microsoft. If you follow precisely the photos (screenshots) used in the instruction, you will findout that when it turns the running stage, the project has different name and look. It is really confusing! I tried also implementing the exact sample which is being used in the instruction. The problem is still there! There is no Run Dag button after creating .py file!
highly appreciate your help!
Jalal
3 Replies
Hi, Jalalmn
"when it turns the running stage, the project has different name and look." Would you mind showing a screenshot of what's different?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI
There was not sample.py in the example. And also no helloworld.py in the example.
I later understood they are just copy pastes from another page which is showing a sample project in Workflow (not about dbt).
So exactly my problem is here, when I get to the running stage, there Run Dag is not visible. I assume, the workflow cannot recognize the DbtDag, and therefore removes the Run Dag button
If you add "from airflow import DAG" at the beginning of your script, it has to work.
