BookmarkSubscribeRSS Feed

Sneak Preview - SAS/ACCESS Interface to Google BigQuery

Started ‎08-07-2019 by
Modified ‎09-18-2019 by
Views 5,763

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.

Comments

That is awesome! Good job!

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

Good news !

 

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

 

Gaetan

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 

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/

Hi,

I confirm that setting in JDBC connexion options :

 

- EnableHighThroughputAPI=1

 

enhance performances.

 

With ODBC, performance are poor reading large datasets

 

Gaetan

 

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

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 !

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?

Hi @Gaetan 

 

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

 

Best wishes,
Jeff

Does this address any issues with BQ and SAS CI?

@chermyMay you precize your issue ?

 

Gaetan

Version history
Last update:
‎09-18-2019 12:55 PM
Updated by:
Contributors

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags