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

# Query Snowflake

> Execute a read-only SQL query against the Snowflake destination of a pipeline. Connection credentials come from the pipeline's configured `credentialsSecret`.



## OpenAPI

````yaml /openapi.yaml post /api/v1/query/snowflake
openapi: 3.0.3
info:
  title: Datris API
  description: >
    REST API for the Datris AI Data Platform. Ingest, validate, transform,
    store, and retrieve data.


    For AI agent integration, use the [MCP
    Server](https://docs.datris.ai/mcp-server) instead.
  version: 1.11.3
  contact:
    name: Datris
    url: https://datris.ai
  license:
    name: Apache 2.0
servers:
  - url: http://localhost:8080
    description: Local development
security:
  - ApiKeyAuth: []
paths:
  /api/v1/query/snowflake:
    post:
      tags:
        - Query
      summary: Query Snowflake
      description: >-
        Execute a read-only SQL query against the Snowflake destination of a
        pipeline. Connection credentials come from the pipeline's configured
        `credentialsSecret`.
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              required:
                - pipeline
              properties:
                pipeline:
                  type: string
                  description: Name of a pipeline with a Snowflake destination
                sql:
                  type: string
                  description: >-
                    SQL query to execute. Omit to select everything from the
                    pipeline's destination table.
                limit:
                  type: integer
                  default: 100
                  description: Maximum rows to return
      responses:
        '200':
          description: Query results including the SQL that was executed
          content:
            application/json:
              schema:
                type: object
                properties:
                  pipeline:
                    type: string
                  sql:
                    type: string
                  results:
                    type: array
                    items:
                      type: object
                  count:
                    type: integer
        '400':
          description: >-
            User-actionable error (e.g. unknown pipeline, no Snowflake
            destination)
          content:
            application/json:
              schema:
                type: object
                properties:
                  error:
                    type: string
        '500':
          description: Error
components:
  securitySchemes:
    ApiKeyAuth:
      type: apiKey
      in: header
      name: x-api-key
      description: Optional API key for authentication (enabled via application.yaml)

````