Create (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.

• A table must currently be created as public. If the request tries to create a private table, it will fail.
• 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.
• To delete a table, you must go to user settings (dune.com) -> data -> delete.
• Creating a table does not incur credits.

curl

curl --request POST \
  --url https://api.dune.com/api/v1/table/my_user/dataset_interest_rates/create \
  --header 'X-DUNE-API-KEY: <x-dune-api-key>' \
  --header 'Content-Type: application/json' \
  --data '{
  "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.

Path Parameters

namespace · string · required

The namespace of the table to create. Must be the name of your associated API key, i.e. either my_user or my_team.

Example:

"my_user"

table_name · string · required

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

Example:

"dataset_my_data"

Body

application/json

Create a new Dune Table for uploads

The body is of type object.

Response

201

application/json

The Dune table namespace.table_name was created successfully.

The response is of type object.