Google BigQuery Connection Setup

[mkiran]

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.

[mkiran]

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.

[mkiran · Accepted solution]

setting the below environment variable in SAS resolved the issue

export GOMEMLIMIT=250MiB