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