SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Google Big Query

Accepted Solution Solved
Reply
Highlighted
Occasional Contributor
Posts: 18
Accepted Solution

Google Big Query

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

 


Accepted Solutions
Solution
‎12-13-2017 10:31 AM
SAS Employee
Posts: 244

Re: Google Big Query

[ Edited ]
Posted in reply to PraveenBala

Hey @PraveenBala,

 

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

 

Here is an SGF paper: An Insider's Guide to SAS/ACCESS Interface to ODBC

 

Best wishes,

Jeff

View solution in original post


All Replies
Super User
Posts: 21,564

Re: Google Big Query

Posted in reply to PraveenBala
Your biggest issue is going to be network bandwith - getting the data to/from whatever analysis method you're employing.
Super User
Posts: 5,624

Re: Google Big Query

Posted in reply to PraveenBala

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.

Data never sleeps
Solution
‎12-13-2017 10:31 AM
SAS Employee
Posts: 244

Re: Google Big Query

[ Edited ]
Posted in reply to PraveenBala

Hey @PraveenBala,

 

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

 

Here is an SGF paper: An Insider's Guide to SAS/ACCESS Interface to ODBC

 

Best wishes,

Jeff

Frequent Learner
Posts: 1

Re: Google Big Query

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

SAS Employee
Posts: 244

Re: Google Big Query

[ Edited ]

Hi @Subhani

 

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

 

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 1869 views
  • 1 like
  • 5 in conversation