BookmarkSubscribeRSS Feed
PhatRam33
Fluorite | Level 6

I am unable to connect and receiving the following error message in SAS and ODBC administrator: ERROR: CLI error trying to establish connection: [Simba][BigQuery] (8701) Error interacting with REST API: Timeout was reached. I increased the timeout threshold in Advanced Options without any luck.

 

It is odd because this was working fine without issues until today.  Any suggestions on what to change in my ODBC settings in ODBC Data Source Administrator to get this to work properly? I'm using Simba ODBC Driver for Google BigQuery.  It seems like a coin flip if connection can be established.

5 REPLIES 5
SASKiwi
PROC Star

If it was working and now it isn't, the problem is identifying the cause and that could involve some diagnosing. Something has changed so it is a matter of finding out what it is. This type of problem is best progressed with Tech Support.

PhatRam33
Fluorite | Level 6

I am querying against a dataset that contains large tables. Anything in advanced options I could try?

SASKiwi
PROC Star

Table size is irrelevant if you can't connect to the database. You can't fix a problem if you don't know the cause. Tech Support is your best option.

PhatRam33
Fluorite | Level 6

I'll reach out to my company's IT support. Figure I post on here just in case. Thanks.

SASKiwi
PROC Star

Good idea. One possible cause is a network / firewall security rule change has blocked access. This is something your IT folks can check out.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1602 views
  • 0 likes
  • 2 in conversation