I’m using dbt to build my models, integrated with Fivetran, and the jobs run after the sync completes. This is great, works like a charm.
I’ve got views that are driving our Power BI dataset. There’s no need for the view to be rewritten every time the underlying jobs run. So, they’re not included in the Fivetran integration.
Once I’m done scripting the Power BI views, I would like to be able to run these models directly into production and update the view instantly.
I can’t wrap my head around what I need to change in my profile, or environment variables to do this. Any help would be much appreciated.