--- title: Validate SQL --- [Skip to content](#_top) [API Reference](https://developers.cloudflare.com/api/typescript) [Pipelines](https://developers.cloudflare.com/api/typescript/resources/pipelines) Copy Markdown Open in **Claude**Open in **ChatGPT**Open in **Cursor** --- **Copy Markdown****View as Markdown** # Validate SQL client.pipelines.validateSql(PipelineValidateSqlParams {account\_id, sql } params, RequestOptionsoptions?): [PipelineValidateSqlResponse]() {tables, graph } 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
params: PipelineValidateSqlParams {account\_id, sql } account\_id: string Path param: Specifies the public ID of the account. Link to this property sql: string Body param: Specifies SQL to validate. Link to this property
[Link to this property](<#(resource)%20pipelines%20%3E%20(method)%20validate_sql%20%3E%20(params)%20default>) ##### ReturnsExpand Collapse
PipelineValidateSqlResponse {tables, graph }
tables: Record<string, Tables> 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?: Graph {edges, nodes } Indicates the processing flow to implement the SQL.
edges: Array<Edge> 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<Node> 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(model)%20pipeline_validate_sql_response%20%3E%20(schema)>) ### Validate SQL TypeScript HTTPTypeScriptPythonGoTerraform ``` import Cloudflare from 'cloudflare'; const client = new Cloudflare({ apiToken: process.env['CLOUDFLARE_API_TOKEN'], // This is the default and can be omitted }); const response = await client.pipelines.validateSql({ account_id: '0123105f4ecef8ad9ca31a8372d0c353', sql: 'insert into sink select * from source;', }); console.log(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 } ```