10 Mar 19 · Ryan-Dallas · #bigquery ·   Bookmark   ×

How to assign a Unique Id for each Row (ROWNUM or ROWID) in Google Bigquery

Often in your data tables you might want to add a unique role identifier. Similar to having your ROWNUM or ROWID in Oracle. Most Users typically use the row number function to generate a unique ID for each row. when you try to do this for large datasets, it thows the below error:

Resources exceeded during query execution: The query could not be 
executed in the allotted memory. OVER() operator used too much memory..


Use generate UUID function. This function will automatically generate a random string for each row, thereby making the row unique




posted on 10 Mar 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds