Snowflake · Schema

SessionParameters

Session parameters that should be set before executing the statement.

DataData WarehouseData LakehouseCloud Data PlatformAnalyticsArtificial IntelligenceData EngineeringData GovernanceSQLApache IcebergModel Context ProtocolT1

Properties

Name	Type	Description
timezone	string	Time zone to use when executing the statement.
query_tag	string	Query tag that you want to associate with the SQL statement.
binary_output_format	string	Output format for binary values.
date_output_format	string	Output format for DATE values.
time_output_format	string	Output format for TIME values.
timestamp_output_format	string	Output format for TIMESTAMP values.
timestamp_ltz_output_format	string	Output format for TIMESTAMP_LTZ values.
timestamp_ntz_output_format	string	Output format for TIMESTAMP_NTZ values.
timestamp_tz_output_format	string	Output format for TIMESTAMP_TZ values.
multi_statement_count	integer	Number of statements to execute when using multi-statement capability. 0 implies variable number of statements. Negative numbers are not allowed.
client_result_chunk_size	integer	Maximum size of each set (chunk) of query results to download.
rows_per_resultset	integer	Maximum number of rows returned in a result set.
use_cached_result	boolean	Whether to use a previously-cached result set for a query whose result set is still in the cache.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "SessionParameters",
  "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."
    },
    "client_result_chunk_size": {
      "type": "integer",
      "description": "Maximum size of each set (chunk) of query results to download."
    },
    "rows_per_resultset": {
      "type": "integer",
      "description": "Maximum number of rows returned in a result set."
    },
    "use_cached_result": {
      "type": "boolean",
      "description": "Whether to use a previously-cached result set for a query whose result set is still in the cache."
    }
  }
}

Work with this as data

Every JSON Schema 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 schemas

4 MCP tools reach this

find_json_schemasBrowse and filter every JSON Schema 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 JSON Schema

curl "https://apis.io/api/v1/json-schemas/snowflake-sql-rest-session-parameters"

All schemas

curl "https://apis.io/api/v1/json-schemas?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.