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

…

Open Full Answer