Sneak Preview - SAS/ACCESS Interface to Google BigQuery

[#1]

We have exciting news. SAS/ACCESS® Interface to Google BigQuery shipped on August 20, 2019! is coming, soon. How soon? August 20, 2019!

SAS/ACCESS Interface to Google BigQuery will:

• Will ship on Linux (64-bit) only
  • SAS® Viya 3.4
    • SAS/ACCESS engine
    • SAS Data Connector for Google BigQuery
  • SAS® 9.4M6
    • SAS/ACCESS engine
    • SAS 9.4M6 is required
  • Be based on native Google BigQuery APIs
    • Not ODBC-based.
  • Include READ and WRITE support
  • Include Bulk Load support
    • Only from SAS data sets
    • Other sources that BigQuery supports are not supported by SAS.
  • Include National Language Support
  • PROC PUSH-DOWN will be supported in an upcoming release.

We will add more features in a subsequent release.

It is essential to understand that SAS 9.4M6 (or higher) or SAS Viya 3.4 (or higher) is a requirement for SAS/ACCESS Interface to Google BigQuery. If you have any questions, feel free to ask me.

[MichaelSean]

That is awesome! Good job!

[NZ_Hockey_Mum]

Just emailed my account manager about getting this installed ... 

[Gaetan]

Good news !

Just an additional question : what is the shipped plan for Windows platform ?

Gaetan

[JBailey]

Hi @Gaetan 

We are in the planning stages. If I had to guess, I would say the product will likely support Windows sometime first half of 2020. As a product manager, I must say, "This is a guess and not a promise."

Best wishes,
Jeff 

[Lorenz]

Does it also support the BigQuery Storage API to read data from BigQuery? My experience (using SAS/ACCESS to ODBC and the newest Simba ODBC driver for BigQuery) is that only with Storage API support you can read large datasets from BigQuery with a reasonable performance.

https://cloud.google.com/bigquery/docs/reference/storage/

[Gaetan]

Hi,

I confirm that setting in JDBC connexion options :

- EnableHighThroughputAPI=1

enhance performances.

With ODBC, performance are poor reading large datasets

Gaetan

[Lorenz]

Hi @Gaetan ,

did you try the latest Simba ODBC driver (version 2.2.1.1006) ? With the option "EnableHTAPI=1" the performance is quite good.

For me SAS/ACCESS to BigQuery is only interesting if it can also use the Storage API.

Lorenz

[Gaetan]

Hi @Lorenz I did not yet use this driver version.

Indeed, following this link https://cloud.google.com/bigquery/providers/simba-drivers/ :

GCP do not propose similar driver version according to language interface !!

- In english language --> 2.2.1.1006

- In french language --> 2.1.23.1031

I test this new version as soon as possible

Thank you !

[Ramakanthkrovi]

We currently use Simba driver to connect to Big Query in 9.4M4 . Is there a paper or demo for what this post refers to?

[Gaetan]

Hi @Ramakanthkrovi Do you know this one :

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/2987-2019.pdf

[JBailey]

Hi @Gaetan 

My post refers to a new product that was released a few weeks ago.

Best wishes,
Jeff

[chermy]

Does this address any issues with BQ and SAS CI?

[Gaetan]

@chermyMay you precize your issue ?

Gaetan