Snowflake Pipe API — pipe

naftiko: 1.0.0-alpha2
info:
  label: Snowflake Pipe API — pipe
  description: 'Snowflake Pipe API — pipe. 5 operations. Lead operation: List Pipes. Self-contained Naftiko capability covering
    one Snowflake business surface.'
  tags:
  - Snowflake
  - pipe
  created: '2026-05-19'
  modified: '2026-05-19'
binds:
- namespace: env
  keys:
    SNOWFLAKE_API_KEY: SNOWFLAKE_API_KEY
capability:
  consumes:
  - type: http
    namespace: pipe-pipe
    baseUri: https://org-account.snowflakecomputing.com
    description: Snowflake Pipe API — pipe business capability. Self-contained, no shared references.
    resources:
    - name: api-v2-databases-database-schemas-schema-pipes
      path: /api/v2/databases/{database}/schemas/{schema}/pipes
      operations:
      - name: listpipes
        method: GET
        description: List Pipes
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: createpipe
        method: POST
        description: Create a Pipe
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: body
          in: body
          type: object
          description: Request body (JSON).
          required: true
    - name: api-v2-databases-database-schemas-schema-pipes-name
      path: /api/v2/databases/{database}/schemas/{schema}/pipes/{name}
      operations:
      - name: fetchpipe
        method: GET
        description: Fetch a Pipe
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
      - name: deletepipe
        method: DELETE
        description: Delete a Pipe
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
    - name: api-v2-databases-database-schemas-schema-pipes-name}:refresh
      path: /api/v2/databases/{database}/schemas/{schema}/pipes/{name}:refresh
      operations:
      - name: refreshpipe
        method: POST
        description: Refresh the Pipe
        outputRawFormat: json
        outputParameters:
        - name: result
          type: object
          value: $.
        inputParameters:
        - name: prefix
          in: query
          type: string
          description: Path (or prefix) appended to the stage reference in the pipe definition. The path limits the set of
            files to load.
        - name: modified_after
          in: query
          type: string
          description: Timestamp (in ISO-8601 format) of the oldest data files to copy into the Snowpipe ingest queue based
            on the LAST_MODIFIED date (i.e. date when a file was staged
  exposes:
  - type: rest
    namespace: pipe-pipe-rest
    port: 8080
    description: REST adapter for Snowflake Pipe API — pipe. One Spectral-compliant resource per consumed operation, prefixed
      with /v1.
    resources:
    - path: /v1/api/v2/databases/{database}/schemas/{schema}/pipes
      name: api-v2-databases-database-schemas-schema-pipes
      description: REST surface for api-v2-databases-database-schemas-schema-pipes.
      operations:
      - method: GET
        name: listpipes
        description: List Pipes
        call: pipe-pipe.listpipes
        outputParameters:
        - type: object
          mapping: $.
      - method: POST
        name: createpipe
        description: Create a Pipe
        call: pipe-pipe.createpipe
        with:
          body: rest.body
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/api/v2/databases/{database}/schemas/{schema}/pipes/{name}
      name: api-v2-databases-database-schemas-schema-pipes-name
      description: REST surface for api-v2-databases-database-schemas-schema-pipes-name.
      operations:
      - method: GET
        name: fetchpipe
        description: Fetch a Pipe
        call: pipe-pipe.fetchpipe
        outputParameters:
        - type: object
          mapping: $.
      - method: DELETE
        name: deletepipe
        description: Delete a Pipe
        call: pipe-pipe.deletepipe
        outputParameters:
        - type: object
          mapping: $.
    - path: /v1/api/v2/databases/{database}/schemas/{schema}/pipes/name-refresh
      name: api-v2-databases-database-schemas-schema-pipes-name-refresh
      description: REST surface for api-v2-databases-database-schemas-schema-pipes-name}:refresh.
      operations:
      - method: POST
        name: refreshpipe
        description: Refresh the Pipe
        call: pipe-pipe.refreshpipe
        with:
          prefix: rest.prefix
          modified_after: rest.modified_after
        outputParameters:
        - type: object
          mapping: $.
  - type: mcp
    namespace: pipe-pipe-mcp
    port: 9090
    transport: http
    description: MCP adapter for Snowflake Pipe API — pipe. One tool per consumed operation, routed inline through this capability's
      consumes block.
    tools:
    - name: list-pipes
      description: List Pipes
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: pipe-pipe.listpipes
      outputParameters:
      - type: object
        mapping: $.
    - name: create-pipe
      description: Create a Pipe
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: pipe-pipe.createpipe
      with:
        body: tools.body
      outputParameters:
      - type: object
        mapping: $.
    - name: fetch-pipe
      description: Fetch a Pipe
      hints:
        readOnly: true
        destructive: false
        idempotent: true
      call: pipe-pipe.fetchpipe
      outputParameters:
      - type: object
        mapping: $.
    - name: delete-pipe
      description: Delete a Pipe
      hints:
        readOnly: false
        destructive: true
        idempotent: true
      call: pipe-pipe.deletepipe
      outputParameters:
      - type: object
        mapping: $.
    - name: refresh-pipe
      description: Refresh the Pipe
      hints:
        readOnly: false
        destructive: false
        idempotent: false
      call: pipe-pipe.refreshpipe
      with:
        prefix: tools.prefix
        modified_after: tools.modified_after
      outputParameters:
      - type: object
        mapping: $.