create_product_nodes_temp_table.sql

CREATE OR REPLACE TEMPORARY TABLE product_nodes_temp
AS
SELECT node_id
     , node_natural_key
     , node_name
     , level_name
     , parent_node_id
     , CASE WHEN parent_node_id IS NULL
               THEN TRUE
               ELSE FALSE
       END AS is_root
     , CASE WHEN node_id IN (SELECT parent_node_id
                               FROM product_nodes
                            )
               THEN FALSE
               ELSE TRUE
       END AS is_leaf
  FROM product_nodes
;