NEW documentation: This article covers setup for OWOX BI. For the latest guides on setting up FREE connectors and Data Marts, visit the new OWOX Data Marts documentation.
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