Is it possible to use DBT to trigger an existing UDF in the database?
We are transitioning to DBT from a tactical ETL solution which is hardcoded in Postgres as a UDF and currently triggered by a data flow tool (Nifi) on a daily basis. As an intermediate solution, we would like to use DBT to trigger the UDF in the database, until we have done the rework required.
Can anyone advise how to go about this. I presume that if I run select * from <function()>, DBT will try to create a table from this select statement rather than running it as a function.