Reserved keywords

Dune Docs

Get Started

Web App

Query Engine

Data Catalog

API Reference

Datashare

Start building

Support

The following table lists all of the keywords that are reserved in DuneSQL, along with their status in the SQL standard. These reserved keywords must be quoted (using double quotes) in order to be used as an identifier.

Dune is a web-based platform that allows you to query public blockchain data and aggregate it into beautiful dashboards.

Welcome

Quickstart

Navigate the Ever-Expanding World of Web3 Data with Ease, from Beginners to Experts

Web3 Data Resources

How to write a query to find out the monthly $ gas spent for your wallet

Create your first query

How to craft AI-assisted queries with ease

Create AI-Assisted Queries

Dune AI Prompt Engineering

Create New Content

How to create a combination bar chart and line chart to visualize the monthly $ gas spent for your wallet

Create your first visualization

Navigate the Query Editor

Find Datasets on Dune

Export Data Out of Dune

Create and Manage Teams

What is the credit system on Dune and how credits work on Dune

Credit System on Dune

How to efficiently search for content on Dune

Search for Content on Dune

Share Dune Content

How to share your query result and charts with others

Share your query

How to transfer ownership of your creations

Transfer Ownership

Dune has built the perfect tools to efficiently extract information from blockchain data.

Overview

The query editor allows you to query blockchain data using DuneSQL.

Writing Queries

The Data Explorer allows you to search for blockchain and other data to use in your Queries. Here's how it works.

Finding Tables

Parameters allow you to implement variables in certain parts of your Query. This is useful if you want to create a Query that you can reuse with different parameters.

Using Parameters

Learn how to leverage the power of query scheduling for a more reliable and up-to-date dashboard display!

Scheduling Queries

Queries have a version history, where you can compare and revert to previous query versions.

Version History

Charts are good for condensing data points into a Visualization. Learn how to make them here

Create Graphs

Counters give you a way to display a single number in a prominent way.

Create counters

Tables are a way to display your data in a tabular format.

Formatting Tables

Dashboards are where Dune's content lives and gets discovered.

Create Dashboards

Instead of working with the logs and traces in their raw states, on Dune we decode smart contract activity into nice human-readable tables.

Decoding Contracts

Dune Teams are shared workspaces for Wizards to collaborate within.

Teams on Dune

Wand is a beta suite of tools for writing SQL queries with the help of large language models.

Dune AI

Upload Data

Embeds allow you to enjoy beautiful, updating Dune charts across the web!

Share your work

Get the most out of Dune's powerful content search functionality

Search content

Alerts allow you to receive notifications based on any query

Alerts

Dune utilizes a fork of TrinoSQL to power DuneSQL. DuneSQL is a custom built query engine that is optimized for blockchain data.

When and how do queries on Dune get executed?

Executions

DuneSQL supports a wide range of built-in functions and operators.

Aggregate functions

Array functions and operators

Base58 functions

Binary

Bitwise

Comparisons

Conditional expressions

Conversions

Date and time functions and operators

Decimal functions and operators

HyperLogLog functions

Lambda expressions are anonymous functions which are passed as arguments to higher-order SQL functions.

Lambda expressions

List of functions by topic

List of functions and operators

Logical operators

Map functions and operators

Mathematical functions and operators

Machine learning functions

Quantile digest functions

Regular expression functions

Set Digest functions

String functions and operators

System information

T-Digest functions

Teradata functions

URL functions

UUID functions

Varbinary functions (DuneSQL)

Window functions

Get the most out of DuneSQL by writing efficient queries.

Writing good queries

The "Query View" feature in DuneSQL allows you to use an existing query as a view in another query. This powerful functionality enables you to create reusable queries, build complex queries, and take advantage of existing queries as views.

Query Views

Materialized tables are a way to store the results of a query in a table that can be queried like any other table. This is useful when you have a query that takes a long time to run, or when you want to use the results of a query in another query.

Materialized Views

Dune's extensive data catalog provides detailed analytics for a wide range of blockchains.

Bring your own data

EVM Overview

Description of the ethereum.transactions table on Dune

Transactions

ethereum.transactions

Description of the ethereum.logs table on Dune

Logs

ethereum.logs

Description of the ethereum.traces table on Dune

Traces

ethereum.traces

Description of the ethereum.creation_traces table on Dune

Creation Traces

ethereum.creation_traces

Description of the ethereum.blocks table on Dune

Blocks

ethereum.blocks

Description of the ethereum.withdrawals table on Dune

Withdrawals

ethereum.withdrawals

Simplifying smart contract analysis through human-readable tables.

On Dune, we parse all message calls and transactions made to smart contracts in their own tables.

Call Tables

Smart Contracts emit event logs when certain predefined actions are completed.

Event Logs

Description of the ethereum.contracts table on Dune

Decoded Contracts

ethereum.contracts

Description of the ethereum.logs_decoded table on Dune

logs_decoded

ethereum.logs_decoded

Description of the ethereum.traces_decoded table on Dune

traces_decoded 

ethereum.traces_decoded

Exploring the landscape of digital assets on the blockchain.

Assets

Balances

tokens_ethereum.balances

Description of the dex.trades table on Dune

DEX Trades

dex.trades

Description of the dex_aggregator.trades table on Dune

DEX Aggregator Trades

dex_aggregator.trades

Description of the nft.trades table on Dune

NFT Trades

nft.trades

Solana Overview

Description of the solana.account_activity table on Dune

Account Activity

solana.account_activity

Description of the solana.blocks table on Dune

solana.blocks

IDL Decoded Tables

Solana Decoded Tables

Description of the solana.instruction_calls table on Dune

Instruction Calls

solana.instruction_calls

Description of the solana.rewards table on Dune

Rewards

solana.rewards

Description of the solana.transactions table on Dune

solana.transactions

Description of the solana.vote_transactions table on Dune

Vote Transactions

solana.vote_transactions

Bitcoin is the first and most well known cryptocurrency.

Bitcoin data

Description of the bitcoin.inputs table on Dune

Inputs

bitcoin.inputs

Description of the bitcoin.outputs table on Dune

Outputs

bitcoin.outputs

Description of the bitcoin.blocks table on Dune

bitcoin.blocks

Description of the bitcoin.transactions table on Dune

bitcoin.transactions

Neynar is the development platform for web3 social protocols. Neynar makes Farcaster protocol data available on Dune.

Keyword	SQL:2016
`ALTER`	reserved
`AND`	reserved
`AS`	reserved
`BETWEEN`	reserved
`BY`	reserved
`CASE`	reserved
`CAST`	reserved
`CONSTRAINT`	reserved
`CREATE`	reserved
`CROSS`	reserved
`CUBE`	reserved
`CURRENT_CATALOG`	reserved
`CURRENT_DATE`	reserved
`CURRENT_PATH`	reserved
`CURRENT_ROLE`	reserved
`CURRENT_SCHEMA`	reserved
`CURRENT_TIME`	reserved
`CURRENT_TIMESTAMP`	reserved
`CURRENT_USER`	reserved
`DEALLOCATE`	reserved
`DELETE`	reserved
`DESCRIBE`	reserved
`DISTINCT`	reserved
`DROP`	reserved
`ELSE`	reserved
`END`	reserved
`ESCAPE`	reserved
`EXCEPT`	reserved
`EXECUTE`	reserved
`EXISTS`	reserved
`EXTRACT`	reserved
`FALSE`	reserved
`FOR`	reserved
`FROM`	reserved
`FULL`	reserved
`GROUP`	reserved
`GROUPING`	reserved
`HAVING`	reserved
`IN`	reserved
`INNER`	reserved
`INSERT`	reserved
`INTERSECT`	reserved
`INTO`	reserved
`IS`	reserved
`JOIN`	reserved
`JSON_ARRAY`	reserved
`JSON_EXISTS`	reserved
`JSON_OBJECT`	reserved
`JSON_QUERY`	reserved
`JSON_VALUE`	reserved
`LEFT`	reserved
`LIKE`	reserved
`LISTAGG`	reserved
`LOCALTIME`	reserved
`LOCALTIMESTAMP`	reserved
`NATURAL`	reserved
`NORMALIZE`	reserved
`NOT`	reserved
`NULL`	reserved
`ON`	reserved
`OR`	reserved
`ORDER`	reserved
`OUTER`	reserved
`PREPARE`	reserved
`RECURSIVE`	reserved
`RIGHT`	reserved
`ROLLUP`	reserved
`SELECT`	reserved
`SKIP`	reserved
`TABLE`	reserved
`THEN`	reserved
`TRIM`	reserved
`TRUE`	reserved
`UESCAPE`	reserved
`UNION`	reserved
`UNNEST`	reserved
`USING`	reserved
`VALUES`	reserved
`WHEN`	reserved
`WHERE`	reserved
`WITH`	reserved

Query Engine

​Reserved keywords

Reserved keywords