Categories:

String & binary functions (AI Functions)

TRANSLATE (SNOWFLAKE.CORTEX)ΒΆ

Translates the given input text from one supported language to another.

Attention

This function does not transform a string given a search string and a replacement string. See the TRANSLATE function if that functionality is what you’re looking for.

SyntaxΒΆ

SNOWFLAKE.CORTEX.TRANSLATE(
    <text>, <source_language>, <target_language>)
Copy

ArgumentsΒΆ

text

A string containing the text to be translated.

source_language

A string specifying the language code for the language the text is currently in. See Usage notes for a list of supported language codes. If the source language code is an empty string, '', the source language is automatically detected.

target_language

A string specifying the language code into which the text should be translated. See Usage notes for a list of supported language codes.

ReturnsΒΆ

A string containing a translation of the original text into the target language.

Usage notesΒΆ

The following languages are supported by the TRANSLATE function. Use the corresponding language code for the source and target language.

The TRANSLATE model also supports a mix of two different languages in the text being translated (for example, β€œSpanglish”). In this case, specify an empty string ('') as the source language to auto-detect the languages used in the source text.

Language

Code

Chinese

'zh'

Dutch

'nl'

English

'en'

French:

'fr'

German

'de'

Hindi

'hi'

Italian

'it'

Japanese

'ja'

Korean

'ko'

Polish

'pl'

Portuguese

'pt'

Russian

'ru'

Spanish

'es'

Swedish

'sv'

The TRANSLATE function produces its best results when either the source or target language is English (for example, English to Spanish or German to English). Results for other language pairs, such as German to Spanish, might be less accurate.

Access control requirementsΒΆ

Users must use a role that has been granted the SNOWFLAKE.CORTEX_USER database role. See Required privileges for more information on this privilege.

ExamplesΒΆ

The following example translates each row of a table from English to German (in this example, review_content is a column from the reviews table):

SELECT SNOWFLAKE.CORTEX.TRANSLATE(review_content, 'en', 'de') FROM reviews LIMIT 10;
Copy

The following example translates a fictitious product review from English to Spanish:

SELECT SNOWFLAKE.CORTEX.TRANSLATE(
  'Hit the slopes with Snowflake\'s latest innovation - "Skii Headphones" designed to keep your ears warm and your soul ablaze. Engineered specifically for snow weather, these rugged headphones combine crystal-clear sound with thermally-insulated ear cups to keep the chill out and the beats in. Whether you\'re carving through powder or cruising down groomers, Skii Headphones will fuel your mountain adventures with vibrant sound and unrelenting passion. Stay warm, stay fired up, and shred the mountain with Snowflake Skii Headphones',
'en','es');
Copy

The result of this query is:

Sube a las pistas con la ΓΊltima innovaciΓ³n de Snowflake: "Skii Headphones", diseΓ±ados para mantener tus oΓ­dos calientes y tu alma encendida. DiseΓ±ados especΓ­ficamente para el clima de nieve, estos audΓ­fonos resistentes combinan un sonido cristalino con copas de oΓ­do aisladas tΓ©rmicamente para mantener el frΓ­o fuera y los ritmos dentro. Ya sea que estΓ©s esculpiendo en polvo o deslizΓ‘ndote por pistas preparadas, los Skii Headphones alimentarΓ‘n tus aventuras en la montaΓ±a con un sonido vibrante y una pasiΓ³n incesante. Mantente caliente, mantente encendido y arrasa la montaΓ±a con los Skii Headphones de Snowflake.

The following example translates a call transcript from German to English:

SELECT SNOWFLAKE.CORTEX.TRANSLATE
  ('Kunde: Hallo
    Agent: Hallo, ich hoffe, es geht Ihnen gut. Um Ihnen am besten helfen zu kΓΆnnen, teilen Sie bitte Ihren Vor- und Nachnamen und den Namen der Firma, von der aus Sie anrufen.
    Kunde: Ja, hier ist Thomas MΓΌller von SkiPisteExpress.
    Agent: Danke Thomas, womit kann ich Ihnen heute helfen?
    Kunde: Also wir haben die XtremeX Helme in Grâße M bestellt, die wir speziell für die kommende Wintersaison benâtigen. Jedoch sind alle Schnallen der Helme defekt, und keiner schließt richtig.
    Agent: Ich verstehe, dass das ein Problem fΓΌr Ihr GeschΓ€ft sein kann. Lassen Sie mich ΓΌberprΓΌfen, was mit Ihrer Bestellung passiert ist. Um zu bestΓ€tigen: Ihre Bestellung endet mit der Nummer 56682?
    Kunde: Ja, das ist meine Bestellung.
    Agent: Ich sehe das Problem. Entschuldigen Sie die Unannehmlichkeiten. Ich werde sofort eine neue Lieferung mit reparierten Schnallen fΓΌr Sie vorbereiten, die in drei Tagen bei Ihnen eintreffen sollte. Ist das in Ordnung fΓΌr Sie?
    Kunde: Drei Tage sind ziemlich lang, ich hatte gehofft, diese Helme frΓΌher zu erhalten. Gibt es irgendeine MΓΆglichkeit, die Lieferung zu beschleunigen?
    Agent: Ich verstehe Ihre Dringlichkeit. Ich werde mein Bestes tun, um die Lieferung auf zwei Tage zu beschleunigen. Wie kommst du damit zurecht?
    Kunde: Das wÀre großartig, ich wÀre Ihnen sehr dankbar.
    Agent: Kein Problem, Thomas. Ich kΓΌmmere mich um die eilige Lieferung. Danke fΓΌr Ihr VerstΓ€ndnis und Ihre Geduld.
    Kunde: Vielen Dank fΓΌr Ihre Hilfe. Auf Wiedersehen!
    Agent: Bitte, gerne geschehen. Auf Wiedersehen und einen schΓΆnen Tag noch!'
,'de','en');
Copy

The result is:

Customer: Hello
Agent: Hello, I hope you are well. To best assist you, please share your first and last name and the name of the company you are calling from.
Customer: Yes, this is Thomas MΓΌller from SkiPisteExpress.
Agent: Thank you, Thomas, what can I help you with today?
Customer: So, we ordered the XtremeX helmets in size M, which we specifically need for the upcoming winter season. However, all the buckles on the helmets are defective and none of them close properly.
Agent: I understand that this can be a problem for your business. Let me check what happened with your order. To confirm: your order ends with the number 56682?
Customer: Yes, that's my order.
Agent: I see the issue. I apologize for the inconvenience. I will prepare a new delivery with repaired buckles for you immediately, which should arrive in three days. Is that okay for you?
Customer: Three days is quite a long time; I was hoping to receive these helmets sooner. Is there any way to expedite the delivery?
Agent: I understand your urgency. I will do my best to expedite the delivery to two days. How does that sound?
Customer: That would be great, I would be very grateful.
Agent: No problem, Thomas. I will take care of the urgent delivery. Thank you for your understanding and patience.
Customer: Thank you very much for your help. Goodbye!
Agent: You're welcome. Goodbye and have a nice day!

Finally, the following example illustrates translating text from two different languages (in this case English and Spanish, or β€œSpanglish”) to English. Note that the specification of the source language is the empty string.

SELECT SNOWFLAKE.CORTEX.TRANSLATE ('Voy a likear tus fotos en Insta.', '', 'en')
Copy

This query results in:

I'm going to like your photos on Insta.

LimitationsΒΆ

Snowflake Cortex functions do not support dynamic tables.

Language: English