Database Reference
In-Depth Information
The most straightforward way to use JDBC with BigQuery is to use the
Simba ODBC driver and use the ODBC to JDBC bridge that is built into Java,
via the
sun.jdbc.odbc.JdbcOdbcDriver
class. However, according to
Oracle's official documentation at
http://docs.oracle.com/javase/7/
docs/technotes/guides/jdbc/bridge.html
,
this class is being deprecated
in Java 8. So if you use this class to connect to your ODBC connections, you
may have a difficult time upgrading to a newer Java runtime.
There is a native JDBC driver that can connect to BigQuery, developed by
StarSchema and released as open source at
https://code.google.com/
p/starschema-bigquery-jdbc/
. Although this JDBC driver does work,
it is not under active development and using it may not be as simple as
plugging it into your current system like other JDBC drivers. The good news
is that because it is open source, if you need to tweak it, you should be able
to update it yourself.
Client-Side Encryption with Encrypted BigQuery
Many potential BigQuery customers aren't comfortable storing their
production data in a public cloud. As the value exposed by “the cloud”
increases, more people are getting over their hesitations. That said, as a
rule of thumb, if you absolutely depend on keeping something secret, you
must encrypt it yourself before using any cloud product, and you should
decrypt it only in your client. The problem is that in order to run interesting
queries, the query engine needs to see unencrypted data. For example,
under ordinary circumstances, you can't compute the sum of an encrypted
field or order by an encrypted value.
As a side note, if you want to protect your data from a government, your
best bet is to store the data in a computer that you never turn on and have
sealed in a lead box. If government X wants your data, it will get it. We don't
want to get involved in speculation about Google's relationship with any
government, other than to say that it is the opinion of the authors that your
data is going to be safest from spying, government or otherwise, in Google's
cloud.
Encrypted BigQuery (
ebq
) is a tool that enables you to encrypt your data
client side and then upload it to BigQuery. The unencrypted source data
never gets sent over the network; the encryption key is never sent over the
network either. As such, there is no way that anyone at Google can decrypt
