topic Re: Google BigQuery Connection Setup in Administration and Deployment

Google BigQuery Connection Setup

mkiran — Tue, 14 May 2024 20:43:07 GMT

Can you guide me the connection setup guide for GoogleBIG Query from SAS9.4 M8 on RHEL?.

We do have license to SAS Access Interface to BigQuery, making direct connection using libname statement through credentail file using BigQuery engine is not working even though we have a 443 port enabled from the server.

Re: Google BigQuery Connection Setup

mkiran — Tue, 14 May 2024 22:03:02 GMT

Below is the error message I received when I try LIBNAME statement after the SAS configuraton is done.

as mentioned, we do have license to SAS/Access interface to BigQuery and I don't think we need do install ODBC drivers on the server.

33 libname BIGQSAS bigquery project="&project." schema="SCHEMA." cred_path=&path. bulkload=YES bulkunload=YES;
ERROR: CLI error trying to establish connection: General Error - invalid Exception
ERROR: Error in the LIBNAME statement.
Error: The connection to the server has been lost.

Re: Google BigQuery Connection Setup

mkiran — Wed, 15 May 2024 00:24:34 GMT

setting the below environment variable in SAS resolved the issue

export GOMEMLIMIT=250MiB