Snowflake · Example Payload

Snowflake Createtableasselect Example

Data LakesData SharingData WarehousingDatabaseSQL

Snowflake Createtableasselect Example is an example object payload from Snowflake, with 6 top-level fields. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

operationIdmethodpathsummaryrequestExamplesresponseExamples

Example Payload

Raw ↑ 
{
  "operationId": "createTableAsSelect",
  "method": "POST",
  "path": "/api/v2/databases/{database}/schemas/{schema}/tables:as-select",
  "summary": "Create a Table Using the Result of the Specified Select Query",
  "requestExamples": [
    {
      "contentType": "application/json",
      "name": "CreatetableasselectRequestExample",
      "example": {
        "name": "Example Title",
        "columns": [
          {
            "name": "Example Title",
            "datatype": "example_value",
            "nullable": true,
            "collate": "example_value",
            "default": "example_value",
            "autoincrement": true,
            "autoincrement_start": 10,
            "autoincrement_increment": 10,
            "constraints": {},
            "comment": "example_value"
          }
        ],
        "cluster_by": [
          "example_value"
        ]
      }
    }
  ],
  "responseExamples": []
}