AI_TRANSLATE

AI_TRANSLATE(
  text,
  source_language,
  target_language
)

SELECT AI_TRANSLATE(
    'Hello, how are you?',
    'en',
    'es'
) AS

SELECT 
    review_id,
    original_language,
    review_text AS original_text,
    AI_TRANSLATE(review_text, original_language, 'en') AS english_translation
FROM international_reviews
WHERE original_language != 'en'

CREATE TABLE product_descriptions_translated AS
SELECT 
    product_id,
    description_en,
    AI_TRANSLATE(description_en, 'en', 'es') AS description_es,
    AI_TRANSLATE(description_en, 'en', 'fr') AS description_fr,
    AI_TRANSLATE(description_en, 'en', 'de') AS description_de,
    AI_TRANSLATE(description_en, 'en', 'zh') AS description_zh
FROM

WITH translated_feedback AS (
    SELECT 
        feedback_id,
        customer_country,
        AI_TRANSLATE(feedback_text, detected_language, 'en') AS feedback_english
    FROM customer_feedback
    WHERE detected_language != 'en'
)
SELECT 
    customer_country,
    AI_SENTIMENT(feedback_english) AS avg_sentiment,
    AI_AGG(
        feedback_english,
        'Summarize common themes in customer feedback'
    ) AS themes
FROM translated_feedback
GROUP BY

SELECT 
    ticket_id,
    customer_language,
    support_response_en,
    AI_TRANSLATE(support_response_en, 'en', customer_language) AS localized_response
FROM support_tickets
WHERE status = 'Awaiting Response'

-- Use AI_CLASSIFY to detect language first
WITH detected_lang AS (
    SELECT 
        message_id,
        message_text,
        AI_CLASSIFY(
            message_text,
            ['en', 'es', 'fr', 'de', 'zh', 'ja']
        ) AS detected_language
    FROM messages
)
SELECT 
    message_id,
    AI_TRANSLATE(message_text, detected_language, 'en') AS english_text
FROM detected_lang
WHERE detected_language != 'en'

-- Keep HTML/Markdown tags intact
SELECT 
    AI_TRANSLATE(
        '<h1>Welcome</h1><p>Thank you for visiting</p>',
        'en',
        'es'
    ) AS translated_html;
-- Output: <h1>Bienvenido</h1><p>Gracias por visitar</p>

-- Avoid re-translating same content
CREATE TABLE translation_cache AS
SELECT DISTINCT
    original_text,
    source_lang,
    target_lang,
    AI_TRANSLATE(original_text, source_lang, target_lang) AS translation,
    CURRENT_TIMESTAMP() AS cached_at
FROM content_to_translate;

-- Use cached translations
SELECT 
    c.content_id,
    COALESCE(tc.translation, AI_TRANSLATE(c.text, 'en', 'es')) AS spanish_text
FROM content c
LEFT JOIN translation_cache tc
    ON c.text = tc.original_text
    AND tc.source_lang = 'en'
    AND tc.target_lang = 'es'

-- For documents > 4096 tokens, split into chunks
WITH text_chunks AS (
    SELECT 
        doc_id,
        SUBSTRING(doc_text, (n - 1) * 4000 + 1, 4000) AS chunk,
        n AS chunk_number
    FROM documents,
         TABLE(GENERATOR(ROWCOUNT => CEIL(LENGTH(doc_text) / 4000.0)))
)
SELECT 
    doc_id,
    LISTAGG(AI_TRANSLATE(chunk, 'en', 'fr'), '') 
        WITHIN GROUP (ORDER BY chunk_number) AS full_translation
FROM text_chunks
GROUP BY

CREATE TABLE product_catalog_global AS
SELECT 
    product_id,
    product_name_en,
    description_en,
    -- Translate to major markets
    AI_TRANSLATE(product_name_en, 'en', 'es') AS product_name_es,
    AI_TRANSLATE(description_en, 'en', 'es') AS description_es,
    AI_TRANSLATE(product_name_en, 'en', 'de') AS product_name_de,
    AI_TRANSLATE(description_en, 'en', 'de') AS description_de
FROM

SELECT 
    ticket_id,
    customer_message_original,
    customer_language,
    AI_TRANSLATE(customer_message_original, customer_language, 'en') AS message_for_agent,
    support_response_en,
    AI_TRANSLATE(support_response_en, 'en', customer_language) AS response_to_customer
FROM

WITH translated_reviews AS (
    SELECT 
        region,
        product_id,
        AI_TRANSLATE(review_text, review_language, 'en') AS review_english
    FROM global_reviews
)
SELECT 
    region,
    product_id,
    AVG(AI_SENTIMENT(review_english)) AS avg_sentiment,
    COUNT(*) AS review_count
FROM translated_reviews
GROUP BY region,

-- Publish blog posts in multiple languages
INSERT INTO published_articles
SELECT 
    article_id,
    'es' AS language,
    AI_TRANSLATE(title, 'en', 'es') AS title,
    AI_TRANSLATE(content, 'en', 'es') AS content,
    author_id,
    CURRENT_TIMESTAMP() AS published_at
FROM

-- Verify translation quality
WITH translation_test AS (
    SELECT 
        original_text,
        AI_TRANSLATE(original_text, 'en', 'es') AS spanish,
        AI_TRANSLATE(
            AI_TRANSLATE(original_text, 'en', 'es'),
            'es',
            'en'
        ) AS back_to_english
    FROM marketing_copy
)
SELECT 
    original_text,
    back_to_english,
    AI_SIMILARITY(original_text, back_to_english) AS quality_score
FROM translation_test
WHERE quality_score < 0.8;  -- Flag low-quality translations