'How do I update a BigQuery table with multiple auto incrementing values?

I have managed to generate a single column based on multiple counts with different prefixes, as detailed here. But now I want to update an existing BigQuery column with that value (my_label) and I am stumped as to how to.

I thought maybe a cte but I don't know how to get the right row within the cte.

sqlgoogle-bigquery


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions