Create Table (beta)

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

This endpoint is currently in beta, and may change without warning.

The resulting table will be empty, and can be inserted into with the /insert endpoint.

• If a table already exists with the same name, the request will fail.
• Column names in the table can’t start with a special character or a digit.
• Each successful table creation consumes 100 credits.
• To delete a table, you can go to user settings (dune.com) -> data -> delete or use the /delete endpoint.

curl

curl --request POST \
  --url https://api.dune.com/api/v1/table/create \
  --header 'X-DUNE-API-KEY: <x-dune-api-key>' \
  --header 'Content-Type: application/json' \
  --data '{
  "namespace":"my_user",
  "table_name":"interest_rates",
  "description": "10 year daily interest rates, sourced from https://fred.stlouisfed.org/series/DGS10",
  "is_private": false,
  "schema": [{"name": "date", "type": "timestamp"}, {"name": "dgs10", "type": "double"}]
}'

Authorizations

x-dune-api-key · string · header · required

The API key of your team or user.

Body

application/json

Create a new Dune Table for uploads

table_name · string · required

The name of the table to create. Must begin with a lowercase letter and contain only lowercase letters, digits, and underscores.

Example:

"my_data"

schema · object[] · required

An ordered list of columns that define the table schema. Cannot be empty.

Show child attributes

namespace · string

The namespace of the table to create. Only the name of your associated API key is allowed at the moment, i.e. either my_user or my_team. (Optional. Default is the namespace of your API key.)

Example:

"my_user"

is_private · boolean · default: false

If true, the table will be private. If private it is only visible to the team or user that your API key is associated with.

description · string

A description of the table.

Response

201

application/json

The Dune table namespace.table_name was created successfully.

namespace · string

The namespace of the created table.

Example:

"my_user"

table_name · string

The name of the created table.

Example:

"my_data"

full_name · string

The full name of the created table, as it should be referred to in a query.

Example:

"dune.my_user.my_data"

example_query · string

An example query to use on Dune querying your new table.

Example:

"select * from dune.my_user.my_data"