Desktop application for querying Bigtable tables with sql
Big Table Viewer is an application that lets you query the contents of Google Bigtable tables with SQL.
Download and run the installer
for your operating system.
To use different credentials than GOOGLE_APPLICATION_CREDENTIALS, click on ‘File’->’Set credentials’.
To add a Bigtable instance click on ‘Add instance’, enter the project and instance id and click ‘Ok’.
The application should display all the tables of the instance.
Click on the table that you would like to query. A default query, selecting the first 1000 rows of the selected table,
should appear in the query box. Click ‘Execute’ to execute the query.
Big table viewer works best with tables where the data in each column corresponds to a standard data type. By clicking
on ‘Table settings’ you can configure how the application should interpret the columns in your table.
Use ‘KEY’ to reference the row key:
SELECT * FROM 'table-0' WHERE KEY LIKE 'row-.*' LIMIT 1000
Use . to reference a column in a column family:
SELECT * FROM 'table-0' WHERE myFamily.myIntColumn > 0 LIMIT 1000
Filter rows based on the value of a column or row key by using standard operators ‘>’, ‘<’, ‘>=’, ‘<=’, ‘=’, ‘!=’, e.g.
SELECT * FROM 'table-0' WHERE myFamily.myStringColumn = 'foo' LIMIT 1000
Use ‘AND’ to combine filters:
SELECT * FROM 'table-0' WHERE KEY LIKE 'rowkey.*' AND myFamily.myStringColumn = 'foo' LIMIT 1000
Only select data from a specific column family:
SELECT myFamily FROM 'table-0' LIMIT 1000
or a list of columns:
SELECT myFamily.column1, myFamily.column2 FROM 'table-0' LIMIT 1000
Filter data based on the cell timestamp:
SELECT * FROM 'table-0' WHERE TIMESTAMP < '2020-12-13 12:54' LIMIT 1000
Count the number of rows satisfying a condition:
SELECT COUNT(*) FROM 'table-0' WHERE TIMESTAMP < '2020-12-13 12:54'
Count the number of rows within a column family satisfying a condition:
SELECT COUNT(myFamily) FROM 'table-0' WHERE TIMESTAMP < '2020-12-13 12:54'
To work with reverse row keys, use the built-in REVERSE function:
SELECT * FROM 'table-0' WHERE KEY LIKE REVERSE('yekwor') LIMIT 1000
in combination with CONCAT:
SELECT * FROM 'table-0' WHERE KEY LIKE CONCAT(REVERSE('yekwor'), '#', '2020-12.*') LIMIT 1000
See licence file.