Convert Bigquery Data From Key-value To Columns

Given some data in BigQuery in the following format: | id | r.key | r.value | +----+-------+---------+ | 1 | k1 | v11 | | +-------+---------+ | | k2 | v12 | |

Solution 1:

Try below

SELECT
  id, 
  MAX(IF(r.key = 'k1', r.value, NULL)) AS k1,
  MAX(IF(r.key = 'k2', r.value, NULL)) AS k2,
  MAX(IF(r.key = 'k3', r.value, NULL)) AS k3      
FROM YourTable
GROUP BY id