Snowflake · Example Payload

Snowflake Submitstatement Example

DataData WarehouseData LakehouseCloud Data PlatformAnalyticsArtificial IntelligenceData EngineeringData GovernanceSQLApache IcebergModel Context ProtocolT1

Snowflake Submitstatement Example is an example object payload from Snowflake, with 6 top-level fields. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

operationIdmethodpathsummaryrequestExamplesresponseExamples

Example Payload

Raw ↑ 
{
  "operationId": "submitStatement",
  "method": "POST",
  "path": "/api/v2/statements",
  "summary": "Submit a Sql Statement for Execution.",
  "requestExamples": [
    {
      "contentType": "application/json",
      "example": {
        "statement": "select * from T where c1=?",
        "timeout": 10,
        "database": "TESTDB",
        "schema": "TESTSCHEMA",
        "warehouse": "TESTWH",
        "role": "TESTROLE",
        "bindings": {
          "1": {
            "type": "FIXED",
            "value": "123"
          }
        }
      }
    }
  ],
  "responseExamples": [
    {
      "status": "200",
      "contentType": "application/json",
      "name": "Submitstatement200Example",
      "example": {
        "code": "example_value",
        "sqlState": "example_value",
        "message": "example_value",
        "statementHandle": "example_value",
        "createdOn": 10,
        "statementStatusUrl": "https://www.example.com",
        "resultSetMetaData": {
          "format": "jsonv2",
          "numRows": 10,
          "rowType": [
            {}
          ],
          "partitionInfo": [
            {}
          ],
          "nullable": true
        },
        "data": [
          [
            "example_value"
          ]
        ],
        "stats": {
          "numRowsInserted": 10,
          "numRowsUpdated": 10,
          "numRowsDeleted": 10,
          "numDuplicateRowsUpdated": 10
        }
      }
    },
    {
      "status": "202",
      "contentType": "application/json",
      "name": "Submitstatement202Example",
      "example": {
        "code": "example_value",
        "sqlState": "example_value",
        "message": "example_value",
        "statementHandle": "example_value",
        "createdOn": 10,
        "statementStatusUrl": "https://www.example.com"
      }
    },
    {
      "status": "408",
      "contentType": "application/json",
      "name": "Submitstatement408Example",
      "example": {
        "code": "example_value",
        "sqlState": "example_value",
        "message": "example_value",
        "statementHandle": "example_value",
        "createdOn": 10,
        "statementStatusUrl": "https://www.example.com"
      }
    },
    {
      "status": "422",
      "contentType": "application/json",
      "name": "Submitstatement422Example",
      "example": {
        "code": "example_value",
        "sqlState": "example_value",
        "message": "example_value",
        "statementHandle": "example_value",
        "createdOn": 10,
        "statementStatusUrl": "https://www.example.com"
      }
    }
  ]
}

Work with this as data

Every example here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for examples

4 MCP tools reach this
  • find_examplesBrowse and filter every example in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This example 
curl "https://apis.io/api/v1/examples/snowflake-submitstatement-example"
All examples 
curl "https://apis.io/api/v1/examples?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.