Confluent

Confluent Materialized Tables (sql/v1) API

[![General Availability](https://img.shields.io/badge/Lifecycle%20Stage-General%20Availability-%2345c6e8)](#section/Versioning/API-Lifecycle-Policy) `MaterializedTable` represents a core resource used to define and manage streaming SQL queries that persist results. The API allows you to list, create, read, update, and delete your materialized tables. ## The Materialized Table Model

GitHub OpenAPI

Operations 5

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

GET /sql/v1/organizations/{organization_id}/environments/{environment_id}/materialized-tables List materialized tables in an environment · List all materialized tables #
Ask an LLM
“Which Flink materialized tables exist in my environment?”
“Can I page through all materialized tables?”
Tell an agent
List materialized tables in environment {environment_id}, org {organization_id}.
Show all materialized tables in env {environment_id} of org {organization_id}, {page_size} per page.
POST /sql/v1/organizations/{organization_id}/environments/{environment_id}/databases/{kafka_cluster_id}/materialized-tables Create a materialized table · Create a materialized table #
Ask an LLM
“How do I create a continuously maintained materialized table with Flink SQL in Confluent?”
“What query and options go into a materialized table spec?”
Tell an agent
Create materialized table {name} in database {kafka_cluster_id}, env {environment_id}, org {organization_id} with spec {spec}.
Define a new materialized table called {name} on cluster {kafka_cluster_id} (env {environment_id}, org {organization_id}).
GET /sql/v1/organizations/{organization_id}/environments/{environment_id}/databases/{kafka_cluster_id}/materialized-tables/{table_name} Get a materialized table · Read a materialized table #
Ask an LLM
“What query and status does one materialized table have?”
“Can I read a materialized table's definition by name?”
Tell an agent
Get materialized table {table_name} in database {kafka_cluster_id}, env {environment_id}, org {organization_id}.
Show the status of materialized table {table_name} on cluster {kafka_cluster_id} (env {environment_id}, org {organization_id}).
PUT /sql/v1/organizations/{organization_id}/environments/{environment_id}/databases/{kafka_cluster_id}/materialized-tables/{table_name} Update or evolve a materialized table · Update/Evolve a materialized table #
Ask an LLM
“Can I change a materialized table's query, compute pool or columns?”
“Is it possible to stop a materialized table without deleting it?”
Tell an agent
Evolve materialized table {table_name} in database {kafka_cluster_id}, env {environment_id}, org {organization_id} to spec {spec}.
Stop materialized table {table_name} on cluster {kafka_cluster_id} in env {environment_id}, org {organization_id} by updating it.
DELETE /sql/v1/organizations/{organization_id}/environments/{environment_id}/databases/{kafka_cluster_id}/materialized-tables/{table_name} Delete a materialized table · Delete a materialized table #
Ask an LLM
“How do I drop a materialized table I no longer need?”
“Can I delete a materialized table by name?”
Tell an agent destructive · confirm first
Delete materialized table {table_name} from database {kafka_cluster_id}, env {environment_id}, org {organization_id}.
Drop the materialized table {table_name} on cluster {kafka_cluster_id} in env {environment_id}, org {organization_id}.

Documentation

📖
APIReference
https://docs.confluent.io/cloud/current/api.html
📖
APIReference
https://api.telemetry.confluent.cloud/docs

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/confluent/refs/heads/main/openapi/confluent-materialized-tables-sql-v1-api-openapi.yml

Work with this as data

Every API 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 apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • 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 API 
curl "https://apis.io/api/v1/apis/confluent:confluent-materialized-tables-sql-v1-api"
All apis 
curl "https://apis.io/api/v1/apis?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.

OpenAPI Specification

confluent-materialized-tables-sql-v1-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Confluent Materialized Tables (sql/v1) API
  version: ''
  x-api-id: 46234552-5833-42eb-ba0f-883ad3f70d2b
  x-audience: external-public
  x-logo:
    url: https://assets.confluent.io/m/1661ef5e4ff82d3d/
  description: 'Operations tagged Materialized Tables (sql/v1) across 2 of this provider''s published API definitions: confluent-cloud-openapi.yaml, confluent-cloud-full.yaml. Each path carries the servers of the definition it was published in.'
servers:
- url: https://api.confluent.cloud
  description: Confluent Cloud API
tags:


# --- truncated at 32 KB (75 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/confluent/refs/heads/main/openapi/confluent-materialized-tables-sql-v1-api-openapi.yml