Snowflake scalar udf in dbt

Hii there,

I was trying to write a snowflake scalar udf in dbt .

I am having issue in creating snowflake udf which returns float value

The udf has to get query result from three different tables and based on each query result has to be passed to another query to get another query output .

Here i am trying to replace the Sqlserver function to snowflake scalar udf .