Reserved keywords

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 Docs

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

How to build a Farcaster Frame using Frog and Dune API

Build a Frame with Dune API

Streamline tracking of your crypto transactions, including profit and loss calculations and determining cost basis, using Dune.

2023 Crypto Profits and Losses with Dune API

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

Web App

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

DuneSQL, a Trino fork, is fine-tuned for blockchain analytics.

Query Engine

When and how do queries on Dune get executed?

Executions

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

Get the most out of DuneSQL by writing efficient queries.

Writing Efficient Queries

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

Data Catalog

Bring your own data

EVM Overview

Aptos is a next-generation blockchain designed for scalability, security, and reliability.

Aptos data

Description of the aptos.blocks table on Dune

Blocks

aptos.blocks

Description of the aptos.transactions table on Dune

Transactions

aptos.transactions

Description of the aptos.user_transactions table on Dune

User Transactions

aptos.user_transactions

Description of the aptos.events table on Dune

Events

aptos.events

Description of the aptos.move_resources table on Dune

Move Resources

aptos.move_resources

Description of the aptos.move_modules table on Dune

Move Modules

aptos.move_modules

Description of the aptos.move_table_items table on Dune

Move Table Items

aptos.move_table_items

Description of the aptos.signatures table on Dune

Signatures

aptos.signatures

Substrate chains (e.g. Polkadot and its parachains) are on Dune.

Polkadot & Substrate Overview

Description of Substrate blocks table on Dune.

polkadot.blocks

Description of Substrate balances tables on Dune.

Balances

polkadot.balances

Description of the polkadot.transfers table on Dune.

Transfers

polkadot.transfers

Description of Substrate extrinsics table on Dune.

Extrinsics

polkadot.extrinsics

Description of Substrate calls tables on Dune.

Calls

polkadot.calls

Description of the Substrate events tables on Dune.

polkadot.events

Description of the polkadot.stakings table on Dune.

Stakings

polkadot.stakings

Description of the polkadot.traces table on Dune.

Traces

polkadot.traces

Useful materialized views for Polkadot, Kusama & their parachains.

TRON Overview

Tether

USDT on tron

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

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

Introduction

Authentication

Client SDKs

Rate Limits

Troubleshooting Errors

Billing

Execution & Results

Tables Management

Query Management

Create a new Dune table with the specified name and namespace.

Create Table (beta)

Insert Data (beta)

This API allows for anyone to upload a CSV as a table in Dune. The size limit per upload is currently 200MB. Your storage is limited by plan, 1MB on free, 15GB on plus, and 50GB on premium.

Upload CSV

Delete Table (beta)

How to recieve data into webhooks from Dune queries

Create Webhook

Pagination

Filtering

Sorting

Sampling

Execute, or run a query for the specified query ID

Execute Query

Cancel a triggered execution request given the execution ID

Cancel Execution

Get Execution Status

Given an execution ID, returns result of a an execution request

Get Execution Result

Given an execution ID, returns result of a an execution request in CSV format

Get Execution Result in CSV

Given a query ID, returns the latest executed result of a query on Dune

Get Latest Query Result

Given a query ID, returns the latest executed result of a query on Dune in CSV format

Get Latest Query Result in CSV

Queries and parameters

This API allows for anyone to create a query. The owner of the query will be under the context of the API key.

Create Query

This API allows for anyone to read the sql text, parameters, name, tags, and state of a query. For private queries, only the API key generated under the context of the owner of that query will work.

Read Query

This API allows for anyone to update the sql text, parameters, name, tags, and state of a query. Only the API key generated under the context of the owner of that query will work.

Update Query

This API allows for anyone to archive a query. Only the API key generated under the context of the owner of that query will work. This does not delete the query, but will make it uneditable/unexecutable

Archive Query

This API allows for anyone to unarchive a query. Only the API key generated under the context of the owner of that query will work.

Unarchive Query

This API allows for anyone to private a query. Only the API key generated under the context of the owner of that query will work.

Private Query

This API allows for anyone to unprivate a query. Only the API key generated under the context of the owner of that query will work.

Unprivate Query

You can access all of Dune's data via the Snowflake data marketplace.

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

Functionality

DuneSQL

​Reserved keywords

Reserved keywords