Snowflake · JSON Structure

Snowflake Structure

Structural overview of the Snowflake API surface; extracted from openapi/.

Type: Properties: 0
Data LakesData SharingData WarehousingDatabaseSQL

Snowflake Structure is a JSON Structure definition published by Snowflake.

Meta-schema:

JSON Structure

Raw ↑
{
  "provider": "Snowflake",
  "providerId": "snowflake",
  "kind": "json-structure",
  "description": "Structural overview of the Snowflake API surface; extracted from openapi/.",
  "schemaCount": 15,
  "operationCount": 16,
  "schemas": [
    {
      "name": "RefreshIcebergTableRequest",
      "type": "object",
      "propertyCount": 1,
      "required": []
    },
    {
      "name": "ConvertToManagedIcebergTableRequest",
      "type": "object",
      "propertyCount": 2,
      "required": []
    },
    {
      "name": "IcebergTable",
      "type": "object",
      "propertyCount": 25,
      "required": [
        "name"
      ]
    },
    {
      "name": "IcebergTableAsSelect",
      "type": "object",
      "propertyCount": 6,
      "required": [
        "name",
        "base_location"
      ]
    },
    {
      "name": "IcebergTableLike",
      "type": "object",
      "propertyCount": 5,
      "required": [
        "name"
      ]
    },
    {
      "name": "IcebergTableClone",
      "type": "object",
      "propertyCount": 2,
      "required": [
        "name"
      ]
    },
    {
      "name": "IcebergTableFromAWSGlueCatalog",
      "type": "object",
      "propertyCount": 8,
      "required": [
        "name",
        "catalog_table_name"
      ]
    },
    {
      "name": "IcebergTableFromIcebergFiles",
      "type": "object",
      "propertyCount": 6,
      "required": [
        "name",
        "metadata_file_path"
      ]
    },
    {
      "name": "IcebergTableFromDelta",
      "type": "object",
      "propertyCount": 6,
      "required": [
        "name",
        "base_location"
      ]
    },
    {
      "name": "IcebergTableFromIcebergRest",
      "type": "object",
      "propertyCount": 8,
      "required": [
        "name",
        "catalog_table_name"
      ]
    },
    {
      "name": "IcebergTableColumn",
      "type": "object",
      "propertyCount": 5,
      "required": [
        "name",
        "datatype"
      ]
    },
    {
      "name": "Constraint",
      "type": "object",
      "propertyCount": 3,
      "required": []
    },
    {
      "name": "PrimaryKey",
      "type": "object",
      "propertyCount": 0,
      "required": []
    },
    {
      "name": "UniqueKey",
      "type": "object",
      "propertyCount": 0,
      "required": []
    },
    {
      "name": "ForeignKey",
      "type": "object",
      "propertyCount": 2,
      "required": [
        "referenced_table_name"
      ]
    }
  ],
  "operations": [
    {
      "method": "GET",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables",
      "operationId": "listIcebergTables",
      "summary": "List Iceberg Tables",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables",
      "operationId": "createSnowflakeManagedIcebergTable",
      "summary": "Create a Snowflake Managed Iceberg Table (clone and Undrop Are Separate Subresources)",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables:as-select",
      "operationId": "createSnowflakeManagedIcebergTableAsSelect",
      "summary": "Create a Snowflake Managed Iceberg Table as Select",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables:from-aws-glue-catalog",
      "operationId": "createUnmanagedIcebergTableFromAWSGlueCatalog",
      "summary": "Create an Unmanaged Iceberg Table From Aws Glue Catalog",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables:from-delta",
      "operationId": "createUnmanagedIcebergTableFromDelta",
      "summary": "Create an Unmanaged Iceberg Table From Delta",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables:from-iceberg-files",
      "operationId": "createUnmanagedIcebergTableFromIcebergFiles",
      "summary": "Create an Unmanaged Iceberg Table From Iceberg Files",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables:from-iceberg-rest",
      "operationId": "createUnmanagedIcebergTableFromIcebergRest",
      "summary": "Create an Unmanaged Iceberg Table From Iceberg Rest",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "GET",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}",
      "operationId": "fetchIcebergTable",
      "summary": "Describe Iceberg Table",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "DELETE",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}",
      "operationId": "dropIcebergTable",
      "summary": "Drop Iceberg Table",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:resume-recluster",
      "operationId": "resumeReclusterIcebergTable",
      "summary": "Resume Recluster of an Iceberg Table",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:suspend-recluster",
      "operationId": "suspendReclusterIcebergTable",
      "summary": "Suspend Recluster of an Iceberg Table",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:refresh",
      "operationId": "refreshIcebergTable",
      "summary": "Refreshes the Metadata for an Apache Iceberg Table That Uses an External Iceberg Catalog",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:convert-to-managed",
      "operationId": "convertToManagedIcebergTable",
      "summary": "Converts an Apache Iceberg\u2122 Table That Uses an External Iceberg Catalog Into a Table That Uses Snowflake as the Catalog",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:undrop",
      "operationId": "undropIcebergTable",
      "summary": "Undrop Iceberg Table",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:clone",
      "operationId": "cloneSnowflakeManagedIcebergTable",
      "summary": "Clone a Snowflake Managed Iceberg Table",
      "tags": [
        "iceberg-table"
      ]
    },
    {
      "method": "POST",
      "path": "/api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:create-like",
      "operationId": "createSnowflakeManagedIcebergTableLike",
      "summary": "Create Iceberg Table Like",
      "tags": [
        "iceberg-table"
      ]
    }
  ]
}