--- title: Validate SQL --- [Skip to content](#_top) [API Reference](https://developers.cloudflare.com/api/python) [Pipelines](https://developers.cloudflare.com/api/python/resources/pipelines) Copy Markdown Open in **Claude**Open in **ChatGPT**Open in **Cursor** --- **Copy Markdown****View as Markdown** # Validate SQL pipelines.validate\_sql(PipelineValidateSqlParams\*\*kwargs) -> [PipelineValidateSqlResponse]() POST/accounts/{account\_id}/pipelines/v1/validate\_sql Validates that the Pipelines SQL is correct. ##### Security
API Token The preferred authorization scheme for interacting with the Cloudflare API. Create a token. **Example:**Authorization: Bearer Sn3lZJTBX6kkg7OdcBUAxOO963GEIyGQqnFTOFYY
API Email + API Key The previous authorization scheme for interacting with the Cloudflare API, used in conjunction with a Global API key. **Example:**X-Auth-Email: user@example.com The previous authorization scheme for interacting with the Cloudflare API. When possible, use API tokens instead of Global API keys. **Example:**X-Auth-Key: 144c9defac04969c7bfad8efaa8ea194
##### Accepted Permissions (at least one required) `Pipelines Write` ##### ParametersExpand Collapse account\_id: str Specifies the public ID of the account. [Link to this property](<#(resource)%20pipelines%20%3E%20(method)%20validate_sql%20%3E%20(params)%20default%20%3E%20(param)%20account_id%20%3E%20(schema)>) sql: str Specifies SQL to validate. [Link to this property](<#(resource)%20pipelines%20%3E%20(method)%20validate_sql%20%3E%20(params)%20default%20%3E%20(param)%20sql%20%3E%20(schema)>) ##### ReturnsExpand Collapse
class PipelineValidateSqlResponse: …
tables: Dict\[str, Tables] Indicates tables involved in the processing. id: str Link to this property name: str Link to this property type: str Link to this property version: float Link to this property
Link to this property
graph: Optional\[Graph] Indicates the processing flow to implement the SQL.
edges: List\[GraphEdge] dest\_id: int formatint32 minimum0 Link to this property edge\_type: str Link to this property key\_type: str Link to this property src\_id: int formatint32 minimum0 Link to this property value\_type: str Link to this property
Link to this property
nodes: List\[GraphNode] description: str Link to this property node\_id: int formatint32 minimum0 Link to this property operator: str Link to this property parallelism: int formatint32 minimum0 Link to this property
Link to this property
Link to this property
[Link to this property](<#(resource)%20pipelines%20%3E%20(model)%20pipeline_validate_sql_response%20%3E%20(schema)>) ### Validate SQL Python HTTPTypeScriptPythonGoTerraform ``` import os from cloudflare import Cloudflare client = Cloudflare( api_token=os.environ.get("CLOUDFLARE_API_TOKEN"), # This is the default and can be omitted ) response = client.pipelines.validate_sql( account_id="0123105f4ecef8ad9ca31a8372d0c353", sql="insert into sink select * from source;", ) print(response.tables) ``` 200 example ``` { "result": { "tables": { "foo": { "id": "id", "name": "name", "type": "type", "version": 0 } }, "graph": { "edges": [ { "dest_id": 0, "edge_type": "edge_type", "key_type": "key_type", "src_id": 0, "value_type": "value_type" } ], "nodes": [ { "description": "description", "node_id": 0, "operator": "operator", "parallelism": 0 } ] } }, "success": true } ``` ##### Returns Examples 200 example ``` { "result": { "tables": { "foo": { "id": "id", "name": "name", "type": "type", "version": 0 } }, "graph": { "edges": [ { "dest_id": 0, "edge_type": "edge_type", "key_type": "key_type", "src_id": 0, "value_type": "value_type" } ], "nodes": [ { "description": "description", "node_id": 0, "operator": "operator", "parallelism": 0 } ] } }, "success": true } ```