---
title: Validate SQL
---
[Skip to content](#_top)
[API Reference](https://developers.cloudflare.com/api)
[Pipelines](https://developers.cloudflare.com/api/resources/pipelines)
Copy Markdown
Open in **Claude**Open in **ChatGPT**Open in **Cursor**
---
**Copy Markdown****View as Markdown**
# Validate SQL
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`
##### P ath ParametersExpand Collapse
account\_id: string
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)>)
##### Body ParametersJSONExpand Collapse
sql: string
Specifies SQL to validate.
[Link to this property](<#(resource)%20pipelines%20%3E%20(method)%20validate_sql%20%3E%20(params)%200%20%3E%20(param)%20sql%20%3E%20(schema)>)
##### ReturnsExpand Collapse
result: object {tables, graph }
tables: map\[object {id, name, type, version } ]
Indicates tables involved in the processing.
id: string
Link to this property
name: string
Link to this property
type: string
Link to this property
version: number
Link to this property
Link to this property
graph: optional object {edges, nodes }
Indicates the processing flow to implement the SQL.
edges: array of object {dest\_id, edge\_type, key\_type, 2 more }
dest\_id: number
formatint32
minimum0
Link to this property
edge\_type: string
Link to this property
key\_type: string
Link to this property
src\_id: number
formatint32
minimum0
Link to this property
value\_type: string
Link to this property
Link to this property
nodes: array of object {description, node\_id, operator, parallelism }
description: string
Link to this property
node\_id: number
formatint32
minimum0
Link to this property
operator: string
Link to this property
parallelism: number
formatint32
minimum0
Link to this property
Link to this property
Link to this property
[Link to this property](<#(resource)%20pipelines%20%3E%20(method)%20validate_sql%20%3E%20(network%20schema)%20%3E%20(property)%20result>)
success: boolean
Indicates whether the API call was successful.
[Link to this property](<#(resource)%20pipelines%20%3E%20(method)%20validate_sql%20%3E%20(network%20schema)%20%3E%20(property)%20success>)
### Validate SQL
HTTP
HTTPTypeScriptPythonGoTerraform
```
curl https://api.cloudflare.com/client/v4/accounts/$ACCOUNT_ID/pipelines/v1/validate_sql \
-H 'Content-Type: application/json' \
-H "Authorization: Bearer $CLOUDFLARE_API_TOKEN" \
-d '{
"sql": "insert into sink select * from source;"
}'
```
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
}
```