> ## Documentation Index > Fetch the complete documentation index at: https://api-docs.select.dev/llms.txt > Use this file to discover all available pages before exploring further. # Generate a code change for an insight > Suggests a rewrite of a query that applies one of the optimization opportunities SELECT detected on it. The rewrite is generated by a language model from the query and its execution profile: treat it as a suggestion and review it before running it. ## OpenAPI ````yaml https://api.select.dev/v2/openapi.json post /insights/actions/generate-code-change openapi: 3.1.0 info: title: SELECT API (v2) version: 0.1.0 servers: - url: https://api.select.dev/v2 description: SELECT API v2 security: [] paths: /insights/actions/generate-code-change: post: tags: - insights summary: Generate a code change for an insight description: >- Suggests a rewrite of a query that applies one of the optimization opportunities SELECT detected on it. The rewrite is generated by a language model from the query and its execution profile: treat it as a suggestion and review it before running it. operationId: generate_code_change_route_insights_actions_generate_code_change_post parameters: - name: x-tenant-id in: header required: true schema: type: string description: The organization ID the request is scoped to. title: X-Tenant-Id description: The organization ID the request is scoped to. requestBody: required: true content: application/json: schema: $ref: '#/components/schemas/CodeChangeRequest' responses: '200': description: Successful Response content: application/json: schema: $ref: '#/components/schemas/CodeChange' '400': $ref: '#/components/responses/BadRequest' '401': $ref: '#/components/responses/Unauthorized' '403': $ref: '#/components/responses/Forbidden' '404': $ref: '#/components/responses/NotFound' '405': $ref: '#/components/responses/MethodNotAllowed' '408': $ref: '#/components/responses/RequestTimeout' '409': $ref: '#/components/responses/Conflict' '422': $ref: '#/components/responses/ValidationFailed' '429': $ref: '#/components/responses/RateLimited' '500': $ref: '#/components/responses/InternalError' '503': $ref: '#/components/responses/ServiceUnavailable' security: - HTTPBearer: [] components: schemas: CodeChangeRequest: properties: query_id: type: string title: Query Id description: >- The Snowflake query id of the query to rewrite. The query must have run in the last 14 days for its execution profile to still be available. query_insight_type: type: string enum: - query-pruning - incremental-query-pruning - incrementalize-dbt-query - incrementalize-ctas-query - inefficient-cortex-function-usage title: Query Insight Type description: Which optimization opportunity to generate a rewrite for. additionalProperties: false type: object required: - query_id - query_insight_type title: CodeChangeRequest description: The query to optimize, and which of its opportunities to act on. CodeChange: properties: new_code: anyOf: - type: string - type: 'null' title: New Code description: >- The rewritten query. Null when no rewrite is being suggested: either the optimization does not apply to this query, or no rewrite was found that improves it. description: anyOf: - type: string - type: 'null' title: Description description: What the rewrite changes, where the change needs explaining. request_id: anyOf: - type: string - type: 'null' title: Request Id description: >- Identifier for this generation. Quote it when reporting a problem with the suggested rewrite. type: object title: CodeChange description: A suggested rewrite of a query. ProblemDetail: additionalProperties: true description: >- RFC 9457-style error payload, served as ``application/problem+json``. ``code`` is the stable, machine-readable identifier — consumers branch on it, never on ``title``. ``type`` stays ``about:blank``: we keep no per-error documentation pages. There is no ``instance``/request-id member (we don't run access logs). See the flat error-code catalogue in §4 of the standards doc. properties: type: default: about:blank title: Type type: string title: type: string title: Title status: title: Status type: integer detail: title: Detail type: string code: title: Code type: string retryable: title: Retryable type: boolean details: anyOf: - items: additionalProperties: true type: object type: array - type: 'null' default: null title: Details required: - title - status - detail - code - retryable title: ProblemDetail type: object responses: BadRequest: description: Bad request content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' Unauthorized: description: Unauthorized content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' headers: WWW-Authenticate: description: Authentication challenge for the requested resource. required: true schema: type: string Forbidden: description: Forbidden content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' NotFound: description: Not found content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' MethodNotAllowed: description: Method not allowed content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' headers: Allow: description: HTTP methods supported by the requested resource. required: true schema: type: string RequestTimeout: description: Request Timeout content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' Conflict: description: Conflict content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' ValidationFailed: description: Validation failed content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' RateLimited: description: Rate limited content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' headers: Retry-After: description: Number of seconds to wait before retrying the request. required: true schema: type: integer minimum: 0 InternalError: description: Internal error content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' ServiceUnavailable: description: Service unavailable content: application/problem+json: schema: $ref: '#/components/schemas/ProblemDetail' headers: Retry-After: description: Number of seconds to wait before retrying the request. required: true schema: type: integer minimum: 0 securitySchemes: HTTPBearer: type: http description: Organization API key (sl_…). scheme: bearer ````