topic Re: Simba Drivers (for Google's BigQuery) in SAS Data Management

Simba Drivers (for Google's BigQuery)

shoin — Wed, 12 Dec 2018 20:32:31 GMT

Is it accurate that the Simba drivers to use with SAS ACCESS/ODBC for connecting to Google's BigQuery, does not offer WRITE capability? I though that this was on the DB if proper GRANTS are given and space/storage allocated. I could be wrong, I do not deal with data too much.

Any insight is appreciated (I plan to research as well)

Thank you in advance,

Re: Simba Drivers (for Google's BigQuery)

SASKiwi — Wed, 12 Dec 2018 21:17:12 GMT

This paper may be helpful: http://support.sas.com/resources/papers/proceedings16/SAS3960-2016.pdf

I can't imagine anyone using ODBC drivers that do not offer WRITE capability - the driver would not be conforming to the ODBC standard if it couldn't write.

Re: Simba Drivers (for Google's BigQuery)

shoin — Tue, 18 Dec 2018 19:39:25 GMT

Thank you, here is a link (below) and I found additional information on jdbc drivers as well as ODBC and it confirmed that there is WRITE capability and large data configuration option as:

https://www.simba.com/products/BigQuery/doc/ODBC_InstallGuide/linux/content/odbc/intro.htm

Thank you.