FunctionInfo

DataArtificial IntelligenceCatalogGovernanceMulti-Modal

Properties

Name	Type	Description
name	string	Name of function, relative to parent schema.
catalog_name	string	Name of parent catalog.
schema_name	string	Name of parent schema relative to its parent catalog.
input_params	object
data_type	object
full_data_type	string	Pretty printed function data type.
return_params	object
routine_body	string	Function language. When EXTERNAL is used, the language of the routine function should be specified in the __external_language__ field, and the __return_params__ of the function cannot be used (as
routine_definition	string	Function body.
routine_dependencies	object
parameter_style	string	Function parameter style. S is the value for SQL.
is_deterministic	boolean	Whether the function is deterministic.
sql_data_access	string	Function SQL data access.
is_null_call	boolean	Function null call.
security_type	string	Function security type.
specific_name	string	Specific name of the function; Reserved for future use.
comment	string	User-provided free-form text description.
properties	string	JSON-serialized key-value pair map, encoded (escaped) as a string.
full_name	string	Full name of function, in form of __catalog_name__.__schema_name__.__function__name__
owner	string	Username of current owner of function.
created_at	integer	Time at which this function was created, in epoch milliseconds.
created_by	string	Username of function creator.
updated_at	integer	Time at which this function was last updated, in epoch milliseconds.
updated_by	string	Username of user who last modified function.
function_id	string	Id of Function, relative to parent schema.
external_language	string	External language of the function.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/unity-catalog/main/json-schema/unity-catalog-function-info-schema.json",
  "title": "FunctionInfo",
  "x-generated": "2026-10-13",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/unitycatalog-all.yaml#/components/schemas/FunctionInfo",
  "type": "object",
  "properties": {
    "name": {
      "description": "Name of function, relative to parent schema.",
      "type": "string"
    },
    "catalog_name": {
      "description": "Name of parent catalog.",
      "type": "string"
    },
    "schema_name": {
      "description": "Name of parent schema relative to its parent catalog.",
      "type": "string"
    },
    "input_params": {
      "$ref": "#/$defs/FunctionParameterInfos"
    },
    "data_type": {
      "$ref": "#/$defs/ColumnTypeName"
    },
    "full_data_type": {
      "description": "Pretty printed function data type.",
      "type": "string"
    },
    "return_params": {
      "$ref": "#/$defs/FunctionParameterInfos"
    },
    "routine_body": {
      "description": "Function language. When **EXTERNAL** is used, the language of the routine function should be specified in the __external_language__ field, \nand the __return_params__ of the function cannot be used (as **TABLE** return type is not supported),\nand the __sql_data_access__ field must be **NO_SQL**.\n",
      "type": "string",
      "enum": [
        "SQL",
        "EXTERNAL"
      ]
    },
    "routine_definition": {
      "description": "Function body.",
      "type": "string"
    },
    "routine_dependencies": {
      "$ref": "#/$defs/DependencyList"
    },
    "parameter_style": {
      "description": "Function parameter style. **S** is the value for SQL.",
      "type": "string",
      "enum": [
        "S"
      ]
    },
    "is_deterministic": {
      "description": "Whether the function is deterministic.",
      "type": "boolean"
    },
    "sql_data_access": {
      "description": "Function SQL data access.",
      "type": "string",
      "enum": [
        "CONTAINS_SQL",
        "READS_SQL_DATA",
        "NO_SQL"
      ]
    },
    "is_null_call": {
      "description": "Function null call.",
      "type": "boolean"
    },
    "security_type": {
      "description": "Function security type.",
      "type": "string",
      "enum": [
        "DEFINER"
      ]
    },
    "specific_name": {
      "description": "Specific name of the function; Reserved for future use.",
      "type": "string"
    },
    "comment": {
      "description": "User-provided free-form text description.",
      "type": "string"
    },
    "properties": {
      "description": "JSON-serialized key-value pair map, encoded (escaped) as a string.",
      "type": "string"
    },
    "full_name": {
      "description": "Full name of function, in form of __catalog_name__.__schema_name__.__function__name__",
      "type": "string"
    },
    "owner": {
      "description": "Username of current owner of function.",
      "type": "string"
    },
    "created_at": {
      "description": "Time at which this function was created, in epoch milliseconds.",
      "type": "integer",
      "format": "int64"
    },
    "created_by": {
      "description": "Username of function creator.",
      "type": "string"
    },
    "updated_at": {
      "description": "Time at which this function was last updated, in epoch milliseconds.",
      "type": "integer",
      "format": "int64"
    },
    "updated_by": {
      "description": "Username of user who last modified function.",
      "type": "string"
    },
    "function_id": {
      "description": "Id of Function, relative to parent schema.",
      "type": "string"
    },
    "external_language": {
      "description": "External language of the function.",
      "type": "string"
    }
  },
  "$defs": {
    "ColumnTypeName": {
      "description": "Name of type (INT, STRUCT, MAP, etc.).",
      "type": "string",
      "enum": [
        "BOOLEAN",
        "BYTE",
        "SHORT",
        "INT",
        "LONG",
        "FLOAT",
        "DOUBLE",
        "DATE",
        "TIMESTAMP",
        "TIMESTAMP_NTZ",
        "STRING",
        "BINARY",
        "DECIMAL",
        "INTERVAL",
        "ARRAY",
        "STRUCT",
        "MAP",
        "VARIANT",
        "CHAR",
        "NULL",
        "USER_DEFINED_TYPE",
        "TABLE_TYPE"
      ]
    },
    "Dependency": {
      "description": "A dependency of a SQL object. Either the __table__ field or the __function__ field must be defined.",
      "type": "object",
      "properties": {
        "table": {
          "$ref": "#/$defs/TableDependency"
        },
        "function": {
          "$ref": "#/$defs/FunctionDependency"
        }
      }
    },
    "DependencyList": {
      "description": "A list of dependencies.",
      "type": "object",
      "properties": {
        "dependencies": {
          "description": "Array of dependencies.",
          "type": "array",
          "items": {
            "$ref": "#/$defs/Dependency"
          }
        }
      }
    },
    "FunctionDependency": {
      "description": "A function that is dependent on a SQL object.",
      "type": "object",
      "required": [
        "function_full_name"
      ],
      "properties": {
        "function_full_name": {
          "description": "Full name of the dependent function, in the form of __catalog_name__.__schema_name__.__function_name__.",
          "type": "string"
        }
      }
    },
    "FunctionParameterInfo": {
      "type": "object",
      "required": [
        "name",
        "type_text",
        "type_name",
        "type_json",
        "position"
      ],
      "properties": {
        "name": {
          "description": "Name of parameter.",
          "type": "string"
        },
        "type_text": {
          "description": "Full data type spec, SQL/catalogString text.",
          "type": "string"
        },
        "type_json": {
          "description": "Full data type spec, JSON-serialized.",
          "type": "string"
        },
        "type_name": {
          "$ref": "#/$defs/ColumnTypeName"
        },
        "type_precision": {
          "description": "Digits of precision; required on Create for DecimalTypes.",
          "type": "integer",
          "format": "int32"
        },
        "type_scale": {
          "description": "Digits to right of decimal; Required on Create for DecimalTypes.",
          "type": "integer",
          "format": "int32"
        },
        "type_interval_type": {
          "description": "Format of IntervalType.",
          "type": "string"
        },
        "position": {
          "description": "Ordinal position of column (starting at position 0).",
          "type": "integer",
          "format": "int32"
        },
        "parameter_mode": {
          "$ref": "#/$defs/FunctionParameterMode"
        },
        "parameter_type": {
          "$ref": "#/$defs/FunctionParameterType"
        },
        "parameter_default": {
          "description": "Default value of the parameter.",
          "type": "string"
        },
        "comment": {
          "description": "User-provided free-form text description.",
          "type": "string"
        }
      }
    },
    "FunctionParameterInfos": {
      "type": "object",
      "properties": {
        "parameters": {
          "description": "The array of __FunctionParameterInfo__ definitions of the function's parameters.",
          "type": "array",
          "items": {
            "$ref": "#/$defs/FunctionParameterInfo"
          }
        }
      }
    },
    "FunctionParameterMode": {
      "description": "The mode of the function parameter.",
      "type": "string",
      "enum": [
        "IN"
      ]
    },
    "FunctionParameterType": {
      "description": "The type of function parameter.",
      "type": "string",
      "enum": [
        "PARAM",
        "COLUMN"
      ]
    },
    "TableDependency": {
      "description": "A table that is dependent on a SQL object.",
      "type": "object",
      "required": [
        "table_full_name"
      ],
      "properties": {
        "table_full_name": {
          "description": "Full name of the dependent table, in the form of __catalog_name__.__schema_name__.__table_name__.",
          "type": "string"
        }
      }
    }
  }
}

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/unity-catalog-function-info"

All schemas

curl "https://apis.io/api/v1/json-schemas?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

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.