Hi All,
I am very much new to dbt , I have a use case where i have one table in snowflake which is having 1 column with non English text , I want to write a code in dbt which will translate that text to English language using google translator. please help in this
When dbt runs SQL models, it’s just creating a SQL query and submitting it to your database. So if you can write a SQL query against your database to do it, you can write a dbt model that will do it. You can usually do things like this with some of the external UDF options the database offers.
Note: @Mike Stanley originally posted this reply in Slack. It might not have transferred perfectly.