Pricing Careers Blog Docs
Login
Decorative drip

Query overview

Queries in Summer are where you will analyze, inspect, and interact with your data. The Query tab contains the:

  • SQL Editor
  • Results Table
  • Chart Builder

SQL Editor

SQL in Summer is based on the DuckDB SQL Syntax. The editor includes functionality for:

  • Auto-completion of SQL keywords, SQL functions, Datasets, Tables, and Columns
  • SQL function helpers on hover
  • Auto-formatting

Most things you would expect in your favorite IDE or text editor are available in the Summer SQL editor. If something’s missing, please let us know.

Results Table

The results table is powered by DuckDB WASM running locally in your browser. Once you run your Query, our Warehouse computes and returns the results directly to your in browser DuckDB instance.

You can filter or sort each column, search your results, or export your results to Parquet/CSV.

Chart Builder

Visualizing your data starts with the Chart Builder. After you run your Query, you can open the Chart builder and choose how to visualize your data.

Because the results of a Query are used to create each Chart, there is a strong link between the two. If you add a new Chart or make changes to an existing one, don’t forget to save your Query. There’s no limit to the number of Charts you can create for a single Query.

See here for a full overview of Charts in Summer

Managing Query access

You can set the permissions on each Query either directly in the Query tab or in the Workspace folder tree. In the Query tab, click the Share icon to the left of the Query name. In the Workspace folder tree, click the ellipses next to the Query and select Share.

Important note

If a Query is inside a Folder, it will inherit permissions from that Folder

In the Query’s share settings, you can set the access level for your entire Org and individuals Users.

The permission levels available are:

Private — Only applicable to your Org’s permission — Ensures no one in your Org can see or use the Query without being granted individual User access.

Viewer — Enables viewing and running the Query.

Editor — All the permissions of Viewer with the ability to edit the Query.

Admin — Grants full access to the item. All permissions in Editor plus the ability to control permissions and delete.