Like most people, we are very impressed with BigQuery. We are ready to put up with the fact that it is based on the proprietary "Dremel" in exchange for the fact that you do not need to configure a ton of servers on our local network, on EC2 or elsewhere.
The REST API works fine, and we have included it in our applications, but we still use the BQ browser interface. We would like to include something like a "common SQL window" in our application, without disclosing that the BQ backend or this data is generally stored by Google. Does Google provide a way to use its BQ browser with a white shortcut ?
Please also note that even expanding access to an existing browser tool is problematic. It is based on user accounts existing in one own domain, which cannot be done in our case with the client's email address. The REST interface allows this with service level accounts, but this does not lead to the use of the SQL window / browser tool.
If people at Google are listening (and I know that you are), consider the advantages of white marking the browser: I think you will find many software companies integrating them into their product packages and then going around any combination of Hadoop / CDH / EMR / Impala / Hive.
So to summarize: how does a software developer import or emulate a BQ browser tool (with all its autocomplete, query history, etc.) in its own web application?
source
share