New: Self-Managed v26! For details, see Release Notes.
Note: To upgrade from v25 to v26, you must upgrade first to v25.2.16+.
Docs Pricing Blog About
Sign In Get Started
Docs Pricing Blog About Sign In
Get Started
  • Get started
    • What is Materialize?
    • Quickstart
    • Download and run Materialize Emulator
    • Install Self-Managed Materialize
    • Concepts
      • Reaction Time, Freshness, and Query Latency
      • Clusters
      • Sources
      • Views
      • Indexes
      • Sinks
      • Namespaces
  • Materialize console
    • Create new
    • SQL Shell
    • Database object explorer
    • Clusters
    • Integrations
    • Monitoring
    • Admin (Cloud-only)
    • Connect (Cloud-only)
    • User profile
  • Self-Managed Deployments
    • Installation
      • Install locally on kind
      • Install on AWS
      • Install on Azure
      • Install on GCP
      • Install Guides (Legacy)
        • Install on AWS(Legacy Terraform)
        • Install on Azure (Legacy Terraform)
        • Install on GCP (Legacy Terraform)
    • Upgrading
      • Upgrade on kind
      • Upgrade on AWS
      • Upgrade on Azure
      • Upgrade on GCP
      • Upgrade Guides (Legacy)
        • Upgrade on AWS (Legacy Terraform)
        • Upgrade on Azure (Legacy Terraform)
        • Upgrade on GCP (Legacy Terraform)
    • Deployment guidelines
      • AWS deployment guidelines
      • Azure deployment guidelines
      • GCP deployment guidelines
    • Materialize Operator Configuration
    • Materialize CRD Field Descriptions
    • Troubleshooting
    • FAQ
    • Self-managed release versions
    • Appendix
      • Prepare for swap and upgrade to v26.0
      • Cluster sizes
      • Legacy Terraform: Releases and configurations
        • Legacy Terraform Releases
        • Required configuration (Legacy AWS Terraform)
        • Required configuration (Legacy Azure Terraform)
        • Required configuration (Legacy GCP Terraform)
  • Ingest data
    • MySQL
      • Amazon Aurora
      • Amazon RDS
      • Azure DB
      • Google Cloud SQL
      • Self-hosted
    • PostgreSQL
      • AlloyDB
      • Amazon Aurora
      • Amazon RDS
      • Azure DB
      • Google Cloud SQL
      • Neon
      • Self-hosted PostgreSQL
      • Troubleshooting
        • Slot overcompacted
        • Connection closed
      • Guide: Handle upstream schema changes with zero downtime
      • FAQ: PostgreSQL sources
    • SQL Server
      • Self-hosted SQL Server
    • MongoDB
    • CockroachDB
      • Using Kafka and Changefeeds
    • Kafka
      • Amazon MSK
      • Confluent Cloud
      • Self-hosted Kafka
      • WarpStream
    • Redpanda
      • Self-hosted Redpanda
      • Redpanda Cloud
    • Webhooks
      • Quickstart
      • Amazon EventBridge
      • HubSpot
      • RudderStack
      • Segment
      • SnowcatCloud
      • Stripe
    • Network configuration
      • Static IP addresses (Cloud-only)
      • AWS PrivateLink connections (Cloud-only)
      • SSH tunnel connections
    • Monitoring data ingestion
    • Troubleshooting
  • Transform data
    • Overview
    • Idiomatic Materialize SQL
      • ANY() equi-join condition
      • First value in group
      • Lag over
      • Last value in group
      • Lead over
      • mz_now() expressions
      • Top-K in group
      • Appendix
        • Idiomatic Materialize SQL chart
        • Window function to idiomatic Materialize
        • Example data: items and orders
    • Patterns
      • Durable subscriptions
      • Partitioning and filter pushdown
      • Percentile calculation
      • Rules execution engine
      • Temporal filters (time windows)
    • Query optimization
    • Troubleshooting
    • FAQ: Indexes
  • Serve results
    • SELECT and SUBSCRIBE
    • Use BI/data collaboration tools
      • Deepnote
      • Hex
      • Metabase
      • Power BI
      • Tableau
      • Looker
    • Use foreign data wrapper (FDW)
    • Sink results
      • Amazon S3
      • S3 Compatible Object Storage
      • Census
      • Kafka and Redpanda
      • Snowflake
      • Troubleshooting sinks
  • Security
    • Cloud
      • User and service accounts
        • Invite users
        • Create service accounts
        • Configure single sign-on (SSO)
      • Access control (Role-based)
        • Manage database roles
      • Manage network policies
    • Self-managed
      • Authentication
      • Access control
        • Manage database roles
    • Appendix
      • Appendix: Privileges
      • Appendix: Privileges by commands
      • Appendix: Built-in roles
  • Manage Materialize
    • Operational guidelines
      • Appendix: Alternative cluster architectures
    • Monitoring and alerting
      • Cloud
        • Datadog
        • Grafana
        • Alerting
      • Self-Managed
        • Grafana using Prometheus
        • Datadog using Prometheus SQL Exporter
        • Alerting
    • Manage with dbt
      • Get started
      • Development workflows
      • Blue-green deployment
      • Slim deployments
    • Manage with Terraform
      • Get started
      • Manage Materialize resources
      • Manage cloud resources
      • Manage privileges
      • Appendix: External secret stores
    • Disaster recovery (Cloud)
      • Materialize Cloud DR characteristics
    • Usage & billing (Cloud)
    • Usage (Self-Managed)
  • Tools and integrations
    • mz - Materialize CLI
      • Installation
      • Configuration
      • mz Reference
        • mz app-password
        • mz config
        • mz profile
        • mz region
        • mz secret
        • mz sql
        • mz user
    • mz-debug Debug tool
      • mz-debug self-managed
      • mz-debug emulator
    • Connection Pooling
    • SQL clients
    • Client libraries
      • Go
      • Java
      • Node.js
      • PHP
      • Python
      • Ruby
      • Rust
    • MCP Server
    • Foreign data wrapper (FDW)
    • HTTP API
    • WebSocket API
  • Reference
    • SQL commands
      • ALTER CLUSTER
      • ALTER CLUSTER REPLICA
      • ALTER CONNECTION
      • ALTER DATABASE
      • ALTER DEFAULT PRIVILEGES
      • ALTER INDEX
      • ALTER MATERIALIZED VIEW
      • ALTER NETWORK POLICY (Cloud)
      • ALTER ROLE
      • ALTER SCHEMA
      • ALTER SECRET
      • ALTER SINK
      • ALTER SOURCE
      • ALTER SYSTEM RESET
      • ALTER SYSTEM SET
      • ALTER TABLE
      • ALTER TYPE
      • ALTER VIEW
      • BEGIN
      • CLOSE
      • COMMENT ON
      • COMMIT
      • COPY FROM
      • COPY TO
      • CREATE CLUSTER
      • CREATE CLUSTER REPLICA
      • CREATE CONNECTION
      • CREATE DATABASE
      • CREATE INDEX
      • CREATE MATERIALIZED VIEW
      • CREATE NETWORK POLICY (Cloud)
      • CREATE ROLE
      • CREATE SCHEMA
      • CREATE SECRET
      • CREATE SINK
        • Kafka/Redpanda
      • CREATE SOURCE
        • Kafka/Redpanda
        • MySQL
        • PostgreSQL (Legacy Syntax)
        • PostgreSQL (New Syntax)
        • SQL Server
        • Webhook
        • Load generator
      • CREATE TABLE
      • CREATE TYPE
      • CREATE VIEW
      • DEALLOCATE
      • DECLARE
      • DELETE
      • DISCARD
      • DROP CLUSTER
      • DROP CLUSTER REPLICA
      • DROP CONNECTION
      • DROP DATABASE
      • DROP INDEX
      • DROP MATERIALIZED VIEW
      • DROP NETWORK POLICY (Cloud)
      • DROP OWNED
      • DROP ROLE
      • DROP SCHEMA
      • DROP SECRET
      • DROP SINK
      • DROP SOURCE
      • DROP TABLE
      • DROP TYPE
      • DROP USER
      • DROP VIEW
      • EXECUTE
      • EXPLAIN ANALYZE
      • EXPLAIN FILTER PUSHDOWN
      • EXPLAIN PLAN
      • EXPLAIN SCHEMA
      • EXPLAIN TIMESTAMP
      • FETCH
      • GRANT PRIVILEGE
      • GRANT ROLE
      • INSERT
      • PREPARE
      • REASSIGN OWNED
      • RESET
      • REVOKE PRIVILEGE
      • REVOKE ROLE
      • ROLLBACK
      • SELECT
        • Joins
        • Recursive CTEs
      • SET
      • SHOW
      • SHOW CLUSTER REPLICAS
      • SHOW CLUSTERS
      • SHOW COLUMNS
      • SHOW CONNECTIONS
      • SHOW CREATE CLUSTER
      • SHOW CREATE CONNECTION
      • SHOW CREATE INDEX
      • SHOW CREATE MATERIALIZED VIEW
      • SHOW CREATE SINK
      • SHOW CREATE SOURCE
      • SHOW CREATE TABLE
      • SHOW CREATE TYPE
      • SHOW CREATE VIEW
      • SHOW DATABASES
      • SHOW DEFAULT PRIVILEGES
      • SHOW INDEXES
      • SHOW MATERIALIZED VIEWS
      • SHOW NETWORK POLICIES (Cloud)
      • SHOW OBJECTS
      • SHOW PRIVILEGES
      • SHOW ROLE MEMBERSHIP
      • SHOW ROLES
      • SHOW SCHEMAS
      • SHOW SECRETS
      • SHOW SINKS
      • SHOW SOURCES
      • SHOW SUBSOURCES
      • SHOW TABLES
      • SHOW TYPES
      • SHOW VIEWS
      • SUBSCRIBE
      • TABLE
      • UPDATE
      • VALIDATE CONNECTION
      • VALUES
    • SQL functions & operators
      • Aggregate function filters
      • array_agg function
      • CAST function and operator