create_table
Define and create structured tables with custom schemas in Dune Analytics for organizing blockchain data analysis.
Instructions
Create a new table with a defined schema.
Args: namespace: Namespace for the table (usually your username). table_name: Name for the table. columns: List of column definitions, each with: - name: Column name - type: Data type ("string", "integer", "double", "timestamp", "boolean") - nullable: Whether nulls are allowed (default True) is_public: Whether the table is publicly accessible.
Returns: Table creation confirmation.
Example: create_table( namespace="my_namespace", table_name="token_metrics", columns=[ {"name": "date", "type": "timestamp", "nullable": False}, {"name": "token", "type": "string"}, {"name": "volume", "type": "double"} ] )
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"namespace": "<namespace>",
"table_name": "<table_name>",
"columns": "<columns>"
},
"name": "create_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| namespace | Yes | ||
| table_name | Yes | ||
| columns | Yes | ||
| is_public | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||