Google Cloud Function to catch BQ Stored proc exception

Question

I am calling BQ Stored proc via Cloud function and have below try catch block

try:

    sql = """CALL `utl.##`(NULL, 1, 3);"""
    job = client.query(sql)
    job.result()
    print("job executed for query:{}".format(sql))
except Exception as e:
    print("error message:  "+job.error_result['message'])
    print(job.exception())

Stored Proc job status is success but one of the statement failed and throw some exception . I would like to capture that in Cloud function. Is there any way?

Answer 1

Solved !! I was able to capture all errors in CF with the change in BQ stored Proc. By properly raising exception message.

EXCEPTION WHEN ERROR THEN
select @@error.message
with 
 EXCEPTION WHEN ERROR THEN  
    RAISE USING MESSAGE = @@error.message ;