Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Bigquery Unnest

Trying to build a bigquery into redshift query and it works in bigquery, but when I try and load it to matillion I am getting the error: No table found with the alias 'trafficSource'.

trafficSource isn't another table it is the nested column name in the bigquery table. I can put bracke

SELECT
visitorId
,fullVisitorId
,visitId
,CONCAT(CAST(fullVisitorId as string), '-', CAST(visitId as string)) as primary_key
,userId
,visitNumber
,visitStartTime
,date
,clientId
,channelGrouping
,socialEngagementType
,h.hitNumber as hits_hitNumber
,trafficSource.adwordsClickInfo.campaignId
FROM
`139139762.ga_sessions_*`,
UNNEST(customDimensions) AS cd,
UNNEST(hits) AS h
WHERE VISITID IN (1530816418)
AND FULLVISITORID = '2426291249686492804'

2 Community Answers

Matillion Agent  

Laura Malins —

Hi Joseph

This is related to your other case. I suggest we pick it up on that ticket.

Thanks
Laura


Joseph Meyer —

Ok, sure this can be closed

Post Your Community Answer

To add an answer please login