snowflake-cloud-sql

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "statementHandle": {
      "type": "string",
      "description": "The handle of the statement that you want to use (e.g. to fetch the result set or cancel execution)."
    },
    "requestId": {
      "type": "string",
      "description": "Unique ID of the API request. This ensures that the execution is idempotent. If not specified, a new UUID is generated and assigned."
    }
  },
  "required": [
    "PCID",
    "statementHandle"
  ]
}

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "statementHandle": {
      "type": "string",
      "description": "The handle of the statement that you want to use (e.g. to fetch the result set or cancel execution)."
    },
    "requestId": {
      "type": "string",
      "description": "Unique ID of the API request. This ensures that the execution is idempotent. If not specified, a new UUID is generated and assigned."
    },
    "partition": {
      "type": "integer",
      "description": "Number of the partition of results to return. The number can range from 0 to the total number of partitions minus 1."
    }
  },
  "required": [
    "PCID",
    "statementHandle"
  ]
}

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "requestId": {
      "type": "string",
      "description": "Unique ID of the API request. This ensures that the execution is idempotent. If not specified, a new UUID is generated and assigned."
    },
    "async": {
      "type": "boolean",
      "description": "Set to true to execute the statement asynchronously and return the statement handle. If the parameter is not specified or is set to false, a statement is executed and the first result is returned if the execution is completed in 45 seconds. If the statement execution takes longer to complete, the statement handle is returned."
    },
    "nullable": {
      "type": "boolean",
      "description": "Set to true to execute the statement to generate the result set including null. If the parameter is set to false, the result set value null will be replaced with a string 'null'."
    },
    "bindings": {
      "type": "object",
      "description": "Values of bind variables in the SQL statement. When executing the statement, Snowflake replaces placeholders ('?' and ':name') in the statement with these specified values."
    },
    "database": {
      "type": "string",
      "description": "Database in which the statement should be executed. The value in this field is case-sensitive."
    },
    "parameters": {
      "type": "object",
      "description": "Session parameters that should be set before executing the statement.",
      "properties": {
        "timezone": {
          "type": "string",
          "description": "Time zone to use when executing the statement."
        },
        "query_tag": {
          "type": "string",
          "description": "Query tag that you want to associate with the SQL statement."
        },
        "binary_output_format": {
          "type": "string",
          "description": "Output format for binary values."
        },
        "date_output_format": {
          "type": "string",
          "description": "Output format for DATE values."
        },
        "time_output_format": {
          "type": "string",
          "description": "Output format for TIME values."
        },
        "timestamp_output_format": {
          "type": "string",
          "description": "Output format for TIMESTAMP values."
        },
        "timestamp_ltz_output_format": {
          "type": "string",
          "description": "Output format for TIMESTAMP_LTZ values."
        },
        "timestamp_ntz_output_format": {
          "type": "string",
          "description": "Output format for TIMESTAMP_NTZ values."
        },
        "timestamp_tz_output_format": {
          "type": "string",
          "description": "Output format for TIMESTAMP_TZ values."
        },
        "multi_statement_count": {
          "type": "integer",
          "description": "Number of statements to execute when using multi-statement capability. 0 implies variable number of statements. Negative numbers are not allowed."
        }
      }
    },
    "role": {
      "type": "string",
      "description": "Role to use when executing the statement. The value in this field is case-sensitive."
    },
    "schema": {
      "type": "string",
      "description": "Schema in which the statement should be executed. The value in this field is case-sensitive."
    },
    "statement": {
      "type": "string",
      "description": "SQL statement or batch of SQL statements to execute. You can specify query, DML and DDL statements. The following statements are not supported: PUT, GET, USE, ALTER SESSION, BEGIN, COMMIT, ROLLBACK, statements that set session variables, and statements that create temporary tables and stages."
    },
    "timeout": {
      "type": "integer",
      "description": "Timeout in seconds for statement execution. If the execution of a statement takes longer than the specified timeout, the execution is automatically canceled. To set the timeout to the maximum value (604800 seconds), set timeout to 0."
    },
    "warehouse": {
      "type": "string",
      "description": "Warehouse to use when executing the statement. The value in this field is case-sensitive."
    }
  },
  "required": [
    "PCID",
    "statement"
  ]
}