blob: 0813d08ad8621367d369d68c47014661f91778fe [file] [log] [blame]
select * from (select d.type type, flatten(d.events) evnts from `data.json` d where d.type='web') s where s.evnts.type = 'cmpgn4';