Hi @belibra Thanks for reaching out & welcome! There are several posts tagged with ai about using the chat component to analyze data from your app 
(For example, this post & this post) 
hope it's helpful!
You could try to use Ask AI or the chat to write the query for updating your big query table, but it may be easier to use our GUI mode & fill in the fields to set up your query:
