This post will cover the fundamental parts of your IDE so you can start getting value out of it right away.

superQuery is broken down into five sections:

  1. Resource Panel
  2. SQL Editor
  3. Results Grid
  4. Visualize Toggle
  5. Right pane


Let's briefly go over what's possible in each section.
 

#1 — Resource Panel

The resource panel contains eight resources, each represented by a unique icon.
 

Projects 

Access all of your projects and BigQuery resources (stored procedures, views, etc.) here.

 

Schema

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.
 

Boards

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.
 


Query History

Query history displays the previous queries you've executed in superQuery and BigQuery.

 

Scheduled Queries

Manage and edit your scheduled queries here. 

 
Integrations

Connect your BI tools (Tableau, Looker, etc.) and data applications (Python, DynamoDB, etc.) to superQuery. 

View the full list of integrations.


GitHub

Connect your GitHub repository to superQuery. 

Once connected, your queries will automatically be backed up, catalogued, and versioned in your repository with each query execution.


Dark Mode / Light Mode toggle

Toggle between Dark Mode and Light Mode with a single click.

Profile

  • View and change your billing plan
  • Set up Team Caching on your own Firebase or DyanmoDB
  • Connect your Google Cloud Storage bucket to save downloaded CSV results there.

#2 — SQL Editor

The SQL Editor is where you write your queries. In the editor, you have the following capabilities to help you work faster and more efficiently:

 

Query Tabs

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 — 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.

 

Variables

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.

 

Smart Compose

Smart Compose helps you write queries much faster while avoiding repetitive mistakes.

Using machine learning, Smart Compose suggests schema and clauses as you write your query.

Currently in beta, you can give it a try by toggling it on in your Query Tab Settings.

 

Query Cost Prediction

Know your query's cost before executing it. Avoid costly mistakes and query with transparency.


Send Queries

Share your query — or a group of queries — with a colleague.

#3 — Results Grid

In your results grid, you can:


#4 — Visualize Queries

The Visualize toggle transforms the results of all of your query tabs into a dashboard in one click — no exporting required.

 

#5 - Right Pane

Your right pane is separated into:

  • Add Tab
  • Shortcuts
  • Format Query
  • Query Scheduler
  • Query Tab Settings
  • Full Screen
  • Hamburger menu 

Add Tab


Click on the "+" icon to open a new query tab.

 

Shortcuts

Click on the shortcuts icon to view a list of the shortcuts available to you in superQuery.
 

 

Format Query

 
One-click query formatting.

If you've been working on a query for a while, sometimes it may not be structured in a clean arrangement.

Formatting will help you to understand the structure of a complex query.

 

Query Scheduler

  

Create a scheduled query here.

Query Tab Settings

Click on the Settings gear icon to open your Query Tab Settings.

Here you can:

  • Select the billing project.
  • Choose your SQL dialect.
  • Set your cache preference.
  • Opt whether to activate Autocomplete or Smart Compose.
  • Create & set a destination table.
  • Set a maximum bytes billed.

 

Full-Screen Mode

 

Hamburger Menu


Here, you have three options:

  • Save View — save the SQL in your active tab as a view.
  • Save To — save a query or queries to another board
  • Download SQL — download a .sql file containing the SQL in your active tab.
Did this answer your question?