Translates the given value using a given dictionary.
TRANSLATE(dictionary, keepValuesWithoutTranslation, emptyAsNull, input)
CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data
MAP_COLUMNS_BY_NAME
SELECT dictionary, keepValuesWithoutTranslation, emptyAsNull, input,
TRANSLATE('a,Antman
b,Batman
d,', false, false, input) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET dictionary = 'a,Antman
b,Batman
d,',
keepValuesWithoutTranslation = false,
emptyAsNull = false,
input = 'a'
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 1;