3CX BigQuery SQL Agent Powered by Gemini & Google ADK

[nikolascx]

Talk to your call center data - no SQL, no dashboards, just questions.​

While Large Language Models excel at reasoning and summarization, they deliver real business value only when connected to structured, governed enterprise data. In this post, we demonstrate how a Google Agent built with the Agent Development Kit (ADK) and Gem...

Continue reading the Original Blog Post.

 

[TonyLin]

We are very interested in testing this feature. However, we noticed that the BigQuery connection relies on the system's Google Integration.

It appears that we cannot set up the Google Integration using a non-enterprise (personal) Google account; it seems strictly required to have a Google Workspace account.

Is there any workaround or method to enable this functionality using a personal Google account?

Thanks!

 

[diplodock]

Additional question. We are already uploading data to the database (Postgre). How can we upload data to an additional database (

BigQuery )​

 

[KyriacosS_3CX]

Hello,

Personal Google accounts might work if you use the Free Tier (that needs a credit card on file), but not long term - for smaller datasets perhaps it will be enough, but both storage and AI tokens have a cost and the free Tier only provides limited amounts. Also I believe it clears out tables periodically, so you might need to export to another DB and push to BigQuery whenever you want to analyse the data in this way - see below.

Google provides a guide for transferring data from Postgres to BigQuery: https://docs.cloud.google.com/bigquery/docs/postgresql-transfer . The PBX itself will only export to one database.