Please see sample code I am running below. What options can I explore to improve speed of query execution in such a scenario? Current full code takes about 4 hrs to run on 1.5 billion rows. Thanks!
SELECT
fullVisitorId
,VisitId
,EventDate
,PagePath
,deviceCategory
FROM ga360.ga_sessions a
WHERE
(
contains(lower(PagePath) , 'step-one')
OR contains(lower(PagePath) , 'step-two')
OR contains(lower(PagePath) , 'step-three')
)
AND not contains(utm_source,'ads')
AND hitstype = 'PAGE'
and a.EventDateKey >= 20200101
