Google Analytics 4 : Advanced query does not work properly/consistent

Matillion ETL
1

So, I have the query for combining 3 datamodels as following :

 

SELECT t.Date, t.Hour, t.DeviceCategory, t.Browser

--, a.SessionSource, a.SessionMedium, a.Sessions 

,t.TotalUsers

--,CAST(NULL as DECIMAL) as PercentNewSessions

, a.NewUsers, CAST(NULL as DECIMAL) as BounceRate

, CASE WHEN a.Sessions=0 THEN 0 else e.ScreenPageViews/a.Sessions END as PageviewsPerSession

,e.userEngagementDuration, CAST(NULL as DECIMAL) as GoalConversionRateAll 

FROM Tech t 

, Engagement e

,Acquisitions a

WHERE t.Date=e.Date and t.Hour=e.Hour 

AND t.Date=a.Date and t.Hour=a.Hour

 

The above query works fine, but when I uncomment lines 2 and 4, there is no data returned.

It shouldn't work as the above, since Im just adding/removing columns from select list. This behavior is buggy

 

2

Hi @Lion9876543211618923990717​

Does this help https://support.matillion.com/s/article/UnabletoaddanewdatasourcewhenusingtheGoogleAnalyticscomponent ?

Thanks,

Chika

3

That works, thank you. Please fix it in next version !