| Table of Contents |
|---|
...
Click on the Create DataSet button. This is like creating a server within BigQuery to hold all the tables within your overall database.
...
If your screenshot looks like the one below, stop and go assign a billing account to the Google project so that you exist sandbox mode.
...
Configure the data set ID, configure it to never expire, and then click create dataset.
...
| Code Block |
|---|
SELECT distinct order_id
FROM `my-data-warehouse.my_dataset.ultracart_orders`
CROSS JOIN UNNEST(items) as i
WHERE DATE(TIMESTAMP(shipping.shipping_date), "America/New_York") = "2021-12-09"
and i.shipped_by_user = 'bob'
and i.merchant_item_id in (
'PRODUCT-A',
'PRODUCT-B'
) order by order_id |
Auto Orders with Pre-shipment Notice Date more than one week prior to shipment.
| Code Block |
|---|
SELECT ao.original_order_id, DATE_DIFF(item.next_preshipment_notice_dts, item.next_shipment_dts, DAY) as days_diff FROM `my-data-warehouse.my_dataset.uc_auto_orders` as ao CROSS JOIN UNNEST(items) as item WHERE enabled = True and item.next_preshipment_notice_dts is not null and DATE_DIFF(item.next_preshipment_notice_dts, item.next_shipment_dts, DAY) < -7 |