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