This post will cover the fundamental parts of the superQuery UI.
superQuery is broken down into five sections:
Let's briefly cover the main capabilities of each section.
The resource panel contains eight resources, each represented by a unique icon.
Boards are like folders, where you can organize your queries by topic, theme, project. Think of them as a filing & management system for your queries.
Access all of your BigQuery projects and resources for other supported services (AWS Athena and DynamoDB) here.
View columns of the table(s) being queried in your current query tab.
Schema is automatically detected based on the tables queried in your SQL.
Query history displays the previous queries you've executed in superQuery and BigQuery.
Manage and edit your scheduled queries here.
Once connected, it's easy to back up queries, catalogue them, and version-control them.
Toggle between Dark Mode and Light Mode with a single click.
Clicking on this icon gives you several options:
Make a feature request
Open superQuery documentation
Access keyboard shortcuts
Open the latest release notes
Check out pricing
View and change your billing plan
Connect your Google Cloud Storage bucket to save downloaded CSV results there.
The SQL Editor is where you write your queries. In the editor, you have the following capabilities for analyzing data faster and more efficiently.
Organize your queries into tabs that you can name & easily identify later.
Tabs allow you to work across multiple queries in one window. The SQL persists across sessions, similar to how you work in a Google Doc — meaning you won't lose your work if you refresh the page or close your session.
With tabs, you can easily jump between queries you're working on.
Know your query's cost before executing it. Avoid costly mistakes and query with transparency.
Variables are placeholders for values that can change.
When you find yourself constantly updating a WHERE clause, then variables can be useful. They make your queries more readable and allow you to perform quick changes on your query without modifying the SQL itself.
Write queries faster using SQL Autocomplete.
Use Manual Commit to add a message to your Git commits, or if you want to commit a change without running the query.
In your results grid, you can:
View, explore, and export query results.
Generate a quick visualization of your query result.
Preview tables and views and see their details.
Make changes to views and commit them to Git
The Visualize toggle transforms the latest results of all of your query tabs into a dashboard in one click — no exporting required.
Your right pane (highlighted below) is separated into the following features
Schedule Query - schedule your current tab's SQL to run at a regularly scheduled interval
Query Tab Settings - modify settings for your query tab like billing project, destination table, and more
Full-Screen Mode - expands your editor view
A "More Options" button which opens
Format Query - formats your current tab's SQL
Save View - saves your current query as a view
Save To - saves your current query tab to a different board
Download SQL - downloads your current query tab's SQL into a .sql file