Snowflake · Example Payload

Snowflake Fetchdynamictable Example

Data LakesData SharingData WarehousingDatabaseSQL

Snowflake Fetchdynamictable 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": "fetchDynamicTable",
  "method": "GET",
  "path": "/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}",
  "summary": "Fetch a Dynamic Table.",
  "requestExamples": [],
  "responseExamples": [
    {
      "status": "200",
      "contentType": "application/json",
      "name": "Fetchdynamictable200Example",
      "example": {
        "name": "Example Title",
        "kind": "PERMANENT",
        "columns": [
          {
            "name": "Example Title",
            "datatype": "example_value",
            "comment": "example_value"
          }
        ],
        "target_lag": {},
        "refresh_mode": "AUTO",
        "initialize": "ON_CREATE",
        "warehouse": "example_value",
        "cluster_by": [
          "example_value"
        ],
        "query": "example_value",
        "data_retention_time_in_days": 10,
        "max_data_extension_time_in_days": 10,
        "comment": "example_value",
        "created_on": "2026-01-15T10:30:00Z",
        "database_name": "example_value",
        "schema_name": "example_value",
        "rows": 10,
        "bytes": 10,
        "scheduling_state": "RUNNING",
        "automatic_clustering": true,
        "owner": "example_value",
        "owner_role_type": "example_value",
        "budget": "example_value"
      }
    }
  ]
}