To query a sample table:
Navigate to Data Workbench > Queries.
Select New Query.
Select sample_datasets.
Write a query of your choice against the table named "www_access". Here is one example query that counts and sorts HTTP requests by their status codes.
SELECT
code AS http_status_code,
COUNT(1) AS num_requests
FROM www_access
GROUP BY code
ORDER BY num_requests
- Select Run. You can monitor the query job status in the Query Result portion of the screen. For example:
- When the job is done, the status changes from RUNNING to SUCCESS. You can also view the results within the Jobs view.
