using bq cli to generate thelook order-items by date

This is a bq cli command that we can use to generate sales data

bq query \

--use_legacy_sql=false \

--format=csv \

'SELECT order_id, product_id, user_id, inventory_item_id, sale_price, status, DATE(created_at) AS sales_date

FROM `bigquery-public-data.thelook_ecommerce.order_items`

WHERE DATE(created_at) = "2025-09-19"' \

> sales-20250919.csv

mitzen