How to access nested field in GA4 BigQuery data table

Consider the following data table:

This data table is for Nov 17, 2025 which is denoted by events_20251117

Let us suppose you want to query the data which meets the following requirements:

1. You want to retrieve the data only for Nov 17, 2025.
2. You want to retrieve the ‘event_date’ and ‘event_name’ columns of the data table.
3. You want to see only those rows where ‘event_name’ = ‘page_view’
4. You want to see the value of ‘page_location’ event parameter as ‘page_location’ column.
5. You want to retrieve only the first 10 rows of the data table.

Follow the steps below:

#1 Navigate to GA4 BigQuery Composer.

GA4 Biguery Composer is a custom ChatGPT I created to generate production-ready SQL for GA4 BigQuery from natural language.

#2 Change your GTP Model to 4.1

#3 Use the following text prompt: