topic Re: Google Big Query in SAS Data Management

Google Big Query

PraveenBala — Sun, 27 Dec 2015 12:14:43 GMT

Hi,

I work with sizeable data, sometimes reaching a few billion rows.

I am exploring ways to use SAS to get data from Google Big Query.

Any body has any experience on that.

Any sample ODBC code or tips will help.

I am using EG on Windows7 64-bit OS as well as Studio on Windows server.

Let me know.

BRgds

Reeza — Sun, 27 Dec 2015 19:16:33 GMT

Your biggest issue is going to be network bandwith - getting the data to/from whatever analysis method you're employing.

LinusH — Sun, 27 Dec 2015 22:11:57 GMT

There is a lot of examples and guides and documentation and papers and...so on, just search support.sas.com.

If you need any Big Query specific syntax, search Google.

JBailey — Wed, 13 Dec 2017 16:20:40 GMT

If Google Big Query is accessible via ODBC, then this paper may help you. Then again it may be totally useless.

Best wishes,

Jeff

Subhani — Thu, 08 Feb 2018 19:45:16 GMT

Hi Jeff,

Can you please share step by step to connect SAS to Google Bigquery on Linux, if you already performed this one?

Please take some examples or screen shorts to explain all steps. I am Facing issues to connect. I felt something is missed.

Regards

Subhani

JBailey — Thu, 08 Feb 2018 21:14:27 GMT

Hum... on Linux... that makes it a little more difficult. I may be able to do this even though it is a lot of work

This post is solved. Please start a new topic for this request. I don't want to overload a solved question.

Keep in mind, this may take a while.

Best wishes,
Jeff