Hi,
I recently been looking into the Agent Builder, creating data stores and agent. However, I'm really struggling to find a way to connect my bigquery table with agent or gemini API (it can easily be connect with a search app though). I can create a datastore using bigquery, but this is incompatible with both the agent and gemini API to be used as a datastore.
Is there any way around?
Is it advisable to go full DIY and try out the embedding and vector search APIs for bigquery data? (Although seems to be lot complicated)