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:
- Resource Panel
- SQL Editor
- Results Grid
- Visualize Toggle
- 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.
Access all of your projects and BigQuery resources (stored procedures, views, etc.) 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.
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 displays the previous queries you've executed in superQuery and BigQuery.
Connect your BI tools (Tableau, Looker, etc.) and data applications (Python, DynamoDB, etc.) to superQuery.
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.
- 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:
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 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 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.
Share your query — or a group of queries — with a colleague.
#3 — Results Grid
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.
#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
- Format Query
- Query Scheduler
- Query Tab Settings
- Full Screen
- Hamburger menu
Click on the "+" icon to open a new query tab.
Click on the shortcuts icon to view a list of the shortcuts available to you in superQuery.
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.
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.
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.