Querylab — web client for Google BigQuery. Read more

We are pleased to present you a new release of our application. Keep on reading, you will find all the updates below.

New authentication features

In addition to standard OAuth authentication it becomes possible to use a service key.

You can read more about authentication methods and security in our application here.

More settings

We are striving to give our users the most convenient tool for working with Google BigQuery, and since all people are different, our duty is to allow customizing the app according to your preferences.

We’ve added a few more settings, so please check which of those works good for you and in case you don’t not find the one you need — leave a comment, let us know.

Saving query results as a pic

There is an often need to share the result of the query with colleagues, while creating a separate Google Sheet is complicated, making a screenshot is inconvenient or it does not include all the data. We came up with a solution and added the ability to download the query results as a picture.

New engine for a query result table

Google BigQuery and Big Data are synonyms. So our application should be able to display a large number of results quickly. We have implemented a new engine for query results — it uses the same technologies as Google Sheets. For the rest everything stays the same: the column names are always within your vision, and you will never get lost with always visible row index.

There are additional funtions available by clicking right on the column name

CTRL + click on the table name

While creating a query you might want to be able to preview the data in the table —since now you can do it in one click.

View previous query results

Sometimes there is a need to view previous results of queries. But restarting a query that has already been completed can be expensive and time-consuming, and the query itself can already be changed beyond recognition. If only there was an opportunity to view previous query results …So here it is.

Random data

In the process of working with data there is an often need to view samples of data in the table. Although the order of data in case of Preview is not determined, data is usually ordered either in loading order or in any other way, so by turning over the pages we will see the same data. To solve the problem we’ve added the ability to view a random page from the query results, please see how it works:

Click on the ellipsis between the pagination to view a random page.

Query and result match indicator

Have you ever been distracted from work so that you could not remember whether you ran the current version of the query, or these are the old results? From now on you do not have to restart queries and pay again — there is an indicator of the query change.

Something else

An improved views support — creating, editing, generating a query script

A lot of intellisense improvements

Bugfixes

Earlier

Ability to save queries

By clicking on the error text, the focus moves to it (if you know the specific location of the problem)

Soon

Custom installations on clients hardware

Thanks for reading till the end, please leave comments (or simply click on the question mark in the upper right corner inside the app), we would love to know what you lack for convinient work with Google BigQuery.

Stay tuned!