SAS Connect To Big Query

[Gaetan]

Hi,

Our datasets are currently stored in Google Big Query.

Access from SAS is done via ODBC Connector (Simba ODBC Connector).

This connector has to be improved by a specific connector, as it is done with Netezza, Oracle and many other DBMS.

Indeed, for example, we can not manage to open Big Query dataset via SAS Enterprise Guide interface using click-button.

There are other issues which impact the usage of SAS.

Could you take my idea in consideration, il will be very helpful for our 80 users ?

Regards,

Gaetan

[VDD]

What is Google big query?

I use SAS to access Oracle and SQL servers with over 800 million records.  I have no issues is opening the tables using ODBC connections besides when other users have the names of the ODBC servers incorrect or better said not following a standard naming.

[Gaetan]

Hi,

BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and machine learning built in.

We access to this database through Simba Drivers for Google BigQuery.

A quite simple example :

data a;
  set b (obs = 10);
run;

Every row are loaded in SAS side, although I need only 10 observations.

Perhaps, there is a workaround.

Currently, I work with the SAS Support to find it.

[Gaetan]

SAS code is not right :

Here is the right code

libname gbq datasrc="DWH_BigQuery";

data a;
  set gbq.b (obs = 10);
run;

[RPoumarede]

For information, SAS/ACCESS to BigQuery is now available in the latest SAS 9 and SAS Viya Ship events (very latest version released week 34 this year).

[Gaetan]

@RPoumaredeThank you !