How to avoid timeout of database connection?

I use Simba ODBC driver to connect BigQuery and fetch the return of a query. Expected return is approximately 2000 x 4 table, less than 1MB. However, sometimes the processing in GCP takes longer than 10min and I face error - 'ODBC Driver Error: ODBC Driver Error: [Simba][BigQuery] (115) Operation timeout. Timed out polling the job.' Can I extend the timeout period?

2 Kommentare

Ganesh
Ganesh am 29 Nov. 2023
The issue seems to be caused from GCP end, kindly try setting a larger timeout from the database end.
Thank you,
Ganesh S
Harry Cho
Harry Cho am 1 Dez. 2023
Bearbeitet: Harry Cho am 1 Dez. 2023
Hi @Ganesh, thank you.

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Produkte

Version

R2022b

Gefragt:

am 17 Nov. 2023

Bearbeitet:

am 1 Dez. 2023

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by