The query editor is the place to query for your data.
.png)
The Query Editor consists of three parts:
- the data explorer on the left
- the query window on the right
- the query results at the bottom
You can change the sizing of each of these parts by dragging the dune logo around.
Let's take a look at each of these parts in more detail.
The data(-set) explorer allows you to search for datasets to use in your queries.
To learn more about Dune's datasets, please visit the section datasets.
You can simply put in any keywords, protocol names, contract names or anything else into the search bar at the top to filter the list of available datasets down to only those you might need at that moment.
The search bar also accepts spaces, that way you can construct a multi keyword search.
Let's explore a few examples of querying for tables to further elaborate on this:
Searching for uniswap_v2. __ will bring up all tables related to the uniswap_v2 schema
Searching for uniswap_v2. evt will bring up only event tables related to the uniswap_v2 schema
Searching for just uniswap will bring up all tables that contain the keyword uniswap in some form.
Takeaways
- Always query for data schemas where applicable
- Use spaces to filter down for events, calls or specific contracts after a schema.\
The query window is where you can work your magic in Dune.
You can input any SQL code and execute it.
.png)
Autocomplete function
You can enable/disable the autocomplete function of the query editor using the gear wheel in the top right corner. The autocomplete feature will only bring up PGSQL keywords and already used tables and aliasses.
.png)
Shortcuts
A few shortcuts to make working in the query editor easier are provided below.\
| Shortcut | Action |
|---|---|
| ctrl + enter | execute the query |
| ctrl + # or / | comments out the selected code |
| ctrl + space | brings up a list of keywords |
| crtl + z | undoes your last changes |
| ctrl + y | redoes your last changes |
| ctrl + f | search for keywords |
| ctrl + h | search and replace keywords |
The query results section contains a table with the results of your query.
.png)
You can change the formatting and appearance of your table with the options below the table. We don't currently support hiding individual columns for displaying this table on a dashboard, but we are looking to implement this function soon.
The tick formats follow this logic:
| Value | Tick format | Output | Description |
|---|---|---|---|
| 1256784.3745 | left blank | 1256784,3745000 | Display the full number and 7 decimals |
| 1256784.3745 | 0 | 1256784 | Only Display whole numbers |
| 1256784.3745 | 0,0 | 1,256,784 | Only displays whole numbers with comma separator |
| 1256784.3745 | 0,0.00 | 1,256,784.38 | Displays the value with decimals points according to the count of zeroes after the dot |
| 1256784.3745 | 0[.]0a | 1.2m | Displays the value in an abbreviated format. Will display decimals of the abbreviated number according to count of zeroes after the dot. |
| 1256784.3745 | $0[.]0a | $1.2m | Adheres to the same methods as before, but adds a $ prefix. |