# Translate any non english text to English

**URL:** <https://discourse.getdbt.com/t/translate-any-non-english-text-to-english/12771>\
**Category:** Help\
**Tags:** dbt-core\
**Created:** [April 5, 2024, 1:05pm UTC](https://discourse.getdbt.com/t/translate-any-non-english-text-to-english/12771 "2024-04-05T13:05:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vipin1985](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@Vipin1985](https://discourse.getdbt.com/u/Vipin1985)\
**Post date:** [April 5, 2024, 1:05pm UTC](https://discourse.getdbt.com/t/translate-any-non-english-text-to-english/12771/1 "2024-04-05T13:05:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![a\_slack\_user](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/a_slack_user/32/1629_2.png) [@a\_slack\_user](https://discourse.getdbt.com/u/a_slack_user)\
**Post date:** [April 5, 2024, 1:47pm UTC](https://discourse.getdbt.com/t/translate-any-non-english-text-to-english/12771/2 "2024-04-05T13:47:58Z")

</div>

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](https://getdbt.slack.com/archives/CBSQTAPLG/p1712324868554359?thread_ts=1712322337.066319&cid=CBSQTAPLG). It might not have transferred perfectly.