DEV Community

ShermeenKiran
ShermeenKiran

Posted on

Answer: Big Query filtering null rows of Custom query creating table

answer re: Big Query filtering null rows of Custom query creating table

Dec 4 '19
1

Below is for BigQuery Standard SQL 

#standardSQL SELECT * FROM ( SELECT (SELECT x.value FROM UNNEST(user_properties) x WHERE x.key='restaurantName' AND x.value IS NOT NULL ).string_value AS restaurantName , (SELECT x.value FROM UNNEST(user_properties) x WHERE x.key='restaurantId' AND x.value IS NOT NULL ).string_value AS restaurantID , (SELECT x.value FROM UNNEST(user_properties) x WHERE
…

Top comments (0)