Use the SQL code below and change {{projectId}}
and {{datasetName}}
to your own.
#Page object
SELECT
page.*
FROM `{{projectId}}.{{datasetName}}._temp_objects`
WHERE page.pageHash IS NOT null
GROUP BY 1,2,3,4
You will get the data in the table 'page' with the schema below:
Field name | Type | |
---|---|---|
pageHash |
STRING | |
hostName |
STRING | |
pagePath |
STRING | |
pageTitle |
STRING |
0 Comments