The public dataset
bigquery-public-data.thelook_ecommerce contains fictitious ecommerce data like
Determine the value (cost of goods) of unsold inventory for each distribution center. Sort the results from high to low.
View the data while you write the query
BigQuery Console's split tab view lets you see your data as you write in the editor. You can open a table in a split pane with
- Cmd+Shift (Mac OS) or
- Ctrl+Shift (Windows) or
- Right click > Move tab to left/right pane
Where is the
- Search for "bigquery-public-data"
- Pin the project
- Clear the search
- Expand the bigquery-public-data project and you should see thelook_ecommerce dataset.