Snowflake data contract | PatchOps Knowledge

Provenance

PublisherSnowflake

API basehttps://api.snowflake.com/

Freshness & coverage

FreshnessFreshness not declared

GeographicNot declared

TemporalNot declared

AuthenticationCredentials required (Bearer token)

Methods (4)

executeSQL

unknown

Execute ad-hoc SQL queries through the Snowflake SQL API.

Required paramssql

Entitiesquery

Input schema

{
  "type": "object",
  "properties": {
    "sql": {
      "type": "string",
      "examples": [
        "SELECT CURRENT_VERSION()"
      ]
    },
    "timeout": {
      "type": "number"
    },
    "warehouse": {
      "type": "string",
      "examples": [
        "COMPUTE_WH"
      ]
    },
    "database": {
      "type": "string"
    },
    "schema": {
      "type": "string"
    },
    "role": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "sql"
  ]
}

Warehouse required unless configured. Accepts one read-only SQL statement.

listDatabases

read

List databases visible to the current credentials.

Input schema

{
  "type": "object",
  "properties": {
    "pattern": {
      "type": "string"
    },
    "warehouse": {
      "type": "string",
      "examples": [
        "COMPUTE_WH"
      ]
    },
    "role": {
      "type": "string"
    }
  },
  "additionalProperties": false
}

Filter: { pattern: "PROD_%" }. Warehouse required unless env set.

listTables

read

List tables within a database/schema combination.

Required paramsdatabaseschema

Input schema

{
  "type": "object",
  "properties": {
    "database": {
      "type": "string",
      "examples": [
        "SNOWFLAKE_SAMPLE_DATA"
      ]
    },
    "schema": {
      "type": "string",
      "examples": [
        "TPCH_SF1"
      ]
    },
    "pattern": {
      "type": "string"
    },
    "warehouse": {
      "type": "string",
      "examples": [
        "COMPUTE_WH"
      ]
    },
    "role": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "database",
    "schema"
  ]
}

describeTable

read

Return column metadata for a specific table (Snowflake).

Required paramsdatabaseschematable

Input schema

{
  "type": "object",
  "properties": {
    "database": {
      "type": "string",
      "examples": [
        "SNOWFLAKE_SAMPLE_DATA"
      ]
    },
    "schema": {
      "type": "string",
      "examples": [
        "TPCH_SF1"
      ]
    },
    "table": {
      "type": "string",
      "examples": [
        "REGION"
      ]
    },
    "warehouse": {
      "type": "string",
      "examples": [
        "COMPUTE_WH"
      ]
    },
    "role": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "database",
    "schema",
    "table"
  ]
}