Update query

​

Key Parameters

• query_id - The ID of the query to update (in the URL path)
• config.sql - The updated SQL query to execute
• config.limit - Maximum number of rows to return
• config.parameters - Updated parameter definitions for templated queries
• config.compute_profile - Updated compute profile identifier

​

Permissions

• Were created by your API key’s organization
• You have edit permissions for

​

Example: Updating Query SQL

curl -X PUT "https://api.allium.so/api/v1/explorer/queries/abc123..." \
  -H "X-API-KEY: your_api_key" \
  -H "Content-Type: application/json" \
  -d '{
    "config": {
      "sql": "SELECT block_number, hash, value FROM ethereum.raw.transactions WHERE block_timestamp > {{start_date}} LIMIT {{limit}}",
      "limit": 5000,
      "parameters": {
        "start_date": "2024-01-01",
        "limit": "5000"
      }
    }
  }'

​

Use Cases

• Optimize SQL - Improve query performance by refining the SQL
• Adjust row limits - Change the maximum number of rows returned
• Update parameters - Modify default parameter values
• Change compute profile - Switch to a different compute resource

​

Next Steps

1. Run the updated query to verify the changes
2. Check the results to ensure they match your expectations