Agent cannot reply relative results from Bigquery

[jacky_enno]

Hi, I just try to use Dialogflow CX. Here are somethings I have done:

1. Upload data including PDF、HTML and Bigquery to Data Store.

2. Ask questions about files and collect the responses.

Although the import process is successful, the agent still don't have access to Bigquery table. PDF and HTML files are successfully loaded by the agent. The following are some snapshots. Hope someone can help me to solve this problem. Thank you very much.

Regards,

Jacky

[lsolatorio]

Hi @jacky_enno, 

Welcome and we appreciate you reaching out to our community.

I understand that you are having challenges retrieving information from BigQuery through your Dialogflow CX agent. You might need to revisit your authentication and access control setup for this matter.

Let me share with you the Dialogflow CX - Integrations document to help you know more about how it works and this troubleshooting document as it can provide insights on the common issues with Dialogflow.

I found a StackOverflow post that is related to your use case, you can check it out as well as it might be helpful.

[jacky_enno]

Hi, thank you for reply.

However, I have a question here.

Can't I just fix the prompt so that the agent can load Bigquery from the data store?

As the relative solution you provided, it looks like we need to write some codes to link the Bigquery and it would generate SQL to get the answer. As I know, the data store supports Bigquery. Therefore, the agent should directly acknowldge Bigquery, isn't it?