Skip to content

AI Translate

AI Translate is a transformation component that uses the Databricks ai_translate() function to invoke generative AI to translate text to a specified target language using SQL. This function uses a Databricks chat model serving endpoint made available by Databricks Foundation Model APIs.

The output is a string translated to the target language.


According to the Databricks documentation, the preview for this function supports translation between English (en) and Spanish (es) only.


Make sure you have read and understand the Requirements set out by Databricks before using this component.


Name = string

A human-readable name for the component.

Columns = column editor

Input Column: The input column that holds text you wish to translate to another language. Target Language: The language to translate to.

Include Input Columns = boolean

  • Yes: Includes both your source language input columns and the new target language translation columns. This will also include those input columns not selected in Columns.
  • No: Only includes the new target language translation columns.

Snowflake Databricks Amazon Redshift