Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Gen AI App Builder - cannot integrate properly datastore from bigquery

I'm genuinely excited about the release of the Gen AI App Builder, now available for general access. I've attempted to set up a chat app that responds to questions using a datastore I had indexed from BigQuery. I even tried integrating it with Dialogflow and added the datastore there, but to no avail.

The documentation has been a challenge to decipher, and most tutorials I found focus on data sources from sites, which I can't verify. If anyone has insights or suggestions to make this process easier, I'd appreciate the guidance.

Thanks,

Ludovico

Solved Solved
1 22 3,796
1 ACCEPTED SOLUTION

I managed to integrate the data from bigquery into the datastore but using a different a different approach.

As reported in the documentation of Gen AI App Builder here are the format supported and example. As you see csv is supported only for Q&A providing pair of questions and answer.
Considering this; I exported from bigquery as csv and converted each of my single row to pdf and it works fine.

https://cloud.google.com/generative-ai-app-builder/docs/agent-data-store

Supported content

There are three types of data stores and each support different types of data.

 

Data store type Supported formats Examples Input mechanism

Webhtml, pdfwww.example.com/*collected from google search index
Unstructuredhtml, pdfmydoc.pdf, private.htmluploaded through Cloud Storage bucket or BigQuery
Structuredcsv"why?","why not"uploaded through Cloud Storage bucket or BigQuery

View solution in original post

22 REPLIES 22