TECH NEWS

Deep dive into BigQuery AI.AGG function

https://storage.googleapis.com/gweb-cloudblog-publish/images/0_-_Hero_Image.max-2600x2600.jpg

We recently announced the preview of the BigQuery AI.AGG() function. With AI.AGG(), you can use natural-language instructions within a single line of SQL to summarize or synthesize information over millions of rows of unstructured or even multimodal data.

While BigQuery already offers powerful AI functions that help you analyze individual rows of data, analyzing unstructured data at scale requires a different approach. AI.AGG() lets you ask questions from unstructured data such as logs and documents, for example:

  • What are the top three feature requests among the negative product reviews?
  • What kind of errors are users seeing most frequently, and how should I start investigating them?
  • In which specific scenarios is our automated agent consistently failing to resolve customer issues?

In this post, we'll dive deeper into the AI.AGG() function and look at a few of the use cases that it unlocks, including how it can be used in combination...

Copyright of this story solely belongs to google.com. To see the full text click HERE

Read more