creamy-sugar-16875
08/25/2023, 11:11 PMProject Id
twice (projectId.projectId.dataset
) instead of putting just the Project Id
and the Dataset
(projectId.dataset
). Is there a way that I can edit the SQL query?future-teacher-7046
creamy-sugar-16875
08/25/2023, 11:33 PMfuture-teacher-7046
creamy-sugar-16875
08/25/2023, 11:41 PM_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}'
from our SQL query and it's now returning results. I'm not 100% sure if this line is necessary or not but when it's included the query return with no data.
Just looking to get your input on if removing this line will cause any issues or if you know why this line is causing us issues?helpful-application-7107
09/01/2023, 8:21 PMcreamy-sugar-16875
09/01/2023, 8:38 PMWITH
__table as (
SELECT
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp,
experiment_id_param.value.string_value AS experiment_id,
variation_id_param.value.int_value AS variation_id,
geo.country as country,
traffic_source.source as source,
traffic_source.medium as medium,
device.category as device,
device.web_info.browser as browser,
device.operating_system as os
FROM
`placeholder`,
UNNEST (event_params) AS experiment_id_param,
UNNEST (event_params) AS variation_id_param
WHERE
_TABLE_SUFFIX BETWEEN '20220901' AND '20230903'
AND event_name = 'experiment_viewed'
AND experiment_id_param.key = 'experiment_id'
AND variation_id_param.key = 'variation_id'
AND user_pseudo_id is not null
)
SELECT
*
FROM
__table
LIMIT
5