google big query http_status_code function not working

[mkgupta]

According to BARD,  BigQuery also has a number of built-in HTTP functions that you can use to get the status code of a URL. 

 SELECT http_status_code("https://www.google.com/") AS status_code 

But I keep getting function not found error. I am using standard SQL.