> ## Documentation Index
> Fetch the complete documentation index at: https://docs.analytics.synapside.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Livre

> Executa queries SQL arbitrárias no schema isolado do projeto.



## OpenAPI

````yaml /openapi.yaml post /api/cdp/sql
openapi: 3.1.0
info:
  title: Synapside CDP API
  description: >-
    API de alta performance do Motor CDP do Synapside para gestão de schemas
    isolados, ingestão de dados em lote (Batch Insert) e execução de consultas
    SQL diretas.
  version: 1.0.0
servers:
  - url: https://cdp.analytics.synapside.com
    description: Servidor de Recebimento (Motor CDP)
security:
  - bearerAuth: []
paths:
  /api/cdp/sql:
    post:
      tags:
        - SQL
      summary: SQL Livre
      description: Executa queries SQL arbitrárias no schema isolado do projeto.
      operationId: executeSql
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              required:
                - sql
              properties:
                sql:
                  type: string
                  example: SELECT * FROM leads WHERE idade > 25
      responses:
        '200':
          description: SQL executado com sucesso.
          content:
            application/json:
              schema:
                oneOf:
                  - $ref: '#/components/schemas/SqlSelectResponse'
                  - $ref: '#/components/schemas/SqlDmlResponse'
                  - $ref: '#/components/schemas/SqlDdlResponse'
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
components:
  schemas:
    SqlSelectResponse:
      type: object
      properties:
        success:
          type: boolean
        type:
          type: string
          enum:
            - SELECT
        rows:
          type: array
          items:
            type: object
        row_count:
          type: integer
    SqlDmlResponse:
      type: object
      properties:
        success:
          type: boolean
        message:
          type: string
        type:
          type: string
          enum:
            - DML
        affected_rows:
          type: integer
    SqlDdlResponse:
      type: object
      properties:
        success:
          type: boolean
        message:
          type: string
        type:
          type: string
          enum:
            - DDL
        command:
          type: string
          example: CREATE TABLE
  responses:
    BadRequest:
      description: Requisição inválida (payload malformado ou erro de validação).
    Unauthorized:
      description: Token não fornecido ou inválido.
    Forbidden:
      description: Acesso negado (CDP inativo ou falta de permissão no banco).
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer

````