Simba Drivers (for Google's BigQuery)

[shoin]

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,

SH

[SASKiwi · Accepted solution]

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.

[shoin]

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.