FIRST_ELEMENT
Last updated
Last updated
Returns the first element in the array.
FIRST_ELEMENT(input)
input
any
null::string
null
array['a', 'b', 'c']
a
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 input,
FIRST_ELEMENT(input) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET input = null::string
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 1;
null::string
null