Translate Tool for Live Query BigQuery
Use the Translate tool to translate text from 1 or more languages to another using AI. This helps make your data accessible across languages.
Use this tool when working with multilingual datasets such as customer feedback, documents, or transcripts.
Tool Availability
The Translate tool is available in the Google BigQuery tool palette.
Before using this tool...
From a Cloud Native workflow, go to Options.
Verify that Enable LiveQuery is enabled.
Verify that the Selected Connection displays a BigQuery connection.
Tool Configuration
Column Name
Use the Column Name dropdown to select the column that contains the text to translate.
Database Schema
Use the Database Schema dropdown to select the schema where the model is hosted.
Model
Use the Model dropdown to select the model used to translate the text.
Target Language
Enter the target language for the translated text.
Output Column Name
Enter a name for the output column in Output Column Name. If you don't specify a name, the tool appends _translate to the input column name.
Output
The tool outputs a new column that contains the translated text for each row.
Permission Required
To use this tool, assign these permissions to the BigQuery project or credentials (service account key or OAuth):
BigQuery APICloud Translation APIVertex AI API