SET order_date = TO_DATE(data.orderDate);
SET buyer_email_hash = MD5(data.buyerEmail);
// GENERATED @ 2020-10-11T20:45:11.427116Z
SELECT time AS processing_time:TIMESTAMP,
data.items[].itemId AS item_id:STRING,
data.items[].price AS item_price:DOUBLE,
data.orderId AS order_id:STRING,
data.netTotal AS order_net_total:DOUBLE,
data.salesTax AS order_sales_tax:DOUBLE,
order_date AS order_date:TIMESTAMP,
buyer_email_hash AS buyer_email_hash:STRING,
data.netTotal + data.salesTax AS order_total:DOUBLE