SET partition_date = UNIX_EPOCH_TO_DATE(time);
SET order_date = TO_DATE('data.orderDate');
// GENERATED @ 2021-01-25T18:28:15.707009Z
SELECT PARTITION_TIME(partition_date) AS partition_date:TIMESTAMP,
time AS processing_time:TIMESTAMP,
data.buyerEmail AS buyeremail:STRING,
data.orderId AS orderid:STRING,
data.netTotal AS nettotal:DOUBLE,
data.salesTax AS salestax:DOUBLE,
data.netTotal + data.salesTax as order_total, //add this line
order_date AS order_date:TIMESTAMP
FROM "upsolver-tutorials-orders"
WHERE data.eventType = 'ORDER' //add this line