CAST

Casts the input expression to the specified type.

Syntax

CAST(<expression> AS <type>) 

Example

Transformation job example

SQL

In the the following example, the nettotal column, which is a double, is converted to a string to enable it to be concatenated with the dollar symbol:

CREATE JOB cast_example
    ADD_MISSING_COLUMNS = true	
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data 
  MAP_COLUMNS_BY_NAME 
    SELECT  orderid,
            '$' || CAST(nettotal AS STRING) AS nettotal,
            orderdate
    FROM    default_glue_catalog.upsolver_samples.orders_raw_data
    LIMIT   3;

Query result

orderid	nettotal	orderdate
cU1QEyPKKc	$2018.37	2023-07-24T15:54:00Z
6eI2KeIc2A	$1842.35	2023-07-24T15:54:00Z
yRQUXyRPTP	$1144.7	2023-07-24T15:54:00Z