Would like to use github actions to schedule runs for a dbt-core project running on postgres adapter.
I am building dbt models from data in an azure database for postgresql. Now i want to do analysis on the transformed data using Power bi or R. Since data is being ingested into the database on a daily basis, i will like to use github actions to schedule dbt runs to run my models so that the analysis will always be based on the latest state of the data in the database. Honestly i haven’t tried any solution yet because i don’t know how to start but then i will appreciate if someone could help on this or suggest an alternative solution. Thank you in advanced.