Trigger an existing UDF in the database

Archive
1

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.

2

I might be wrong here - since I don’t need to do it - but Isn’t this someting you could do possibly with Hooks and Operations?

1 Like
3

Thanks! Solution found! I’ve created an operation to trigger the function.