My old BigQuery bookmarks don’t work anymore -Solved-

I love BigQuery. There was a cosy place in my heart for the classic UI which is sadly deprecated as of October 1st.

Problem

Unfortunately I had a lot of bookmark URLs kept for jobs processed in the old I might have to refer to in the future. I was shocked to discover that bookmarks to jobs in the old UI will not redirect to the job in the new UI.

Solution

Fortunately enough, translating the bookmarked URLs to the new UI format is quite simple. Follow this link to Google Sheet with the equation to transform old BigQuery UI job links to new ones.

Did you find this useful? Let’s us know below!