Google Big Query: alternatives to browser SQL editor?

romanoww picture romanoww · Oct 15, 2018 · Viewed 7.9k times · Source

I'm currently working a lot with Google Big Query and I absolutely hate querying in-browser. I'm used to connect to regular DB's through editors like Toad, Microsoft SQL Studio, Teradata Studio Express or Databeaver. I'm look for a similar tool that you guys would recommend for using on Google Big Query.

Only alternative I've found so far are razorsql and jetbrains datagrip (whereas the latter requires a custom connection (https://blog.jetbrains.com/datagrip/2018/07/10/using-bigquery-from-intellij-based-ide/)

Any idea's on alternatives out there?

Thanks in advance

Answer

FKrauss picture FKrauss · Oct 24, 2018

There's a thread on reddit with some recommendations. I personally like the UI and there's a new UI coming (but doesn't seem to change much in functionality, only styling).

Some of the recommendations are:

  1. DataGrip
  2. Aquafold
  3. Metabase
  4. Potens
  5. PopSql

Plus a few other tools that aren't RDMBs per se but have the components to "run queries" not in the UI, like Mode Analytics.

I haven't personally used any of them, but take it for a spin and see which one you like the most! (share your insights here later as I'm also curious about it)