materialize-docs

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Materialize Documentation

Materialize 文档

This skill provides comprehensive documentation for Materialize, a streaming database for real-time analytics.

本技能提供Materialize的全面文档，Materialize是一款用于实时分析的流处理数据库。

How to Use This Skill

如何使用本技能

When a user asks about Materialize:

For SQL syntax/commands: Read files in the
```
sql/
```
directory
For core concepts: Read files in the
```
concepts/
```
directory
For data ingestion: Read files in the
```
ingest-data/
```
directory
For transformations: Read files in the
```
transform-data/
```
directory

当用户询问Materialize相关问题时：

关于SQL语法/命令：查阅
```
sql/
```
目录下的文件
关于核心概念：查阅
```
concepts/
```
目录下的文件
关于数据摄入：查阅
```
ingest-data/
```
目录下的文件
关于数据转换：查阅
```
transform-data/
```
目录下的文件

Documentation Sections

文档章节

Administrations

管理

Usage (Self-Managed):
```
administration/usage/index.md
```
Usage & billing (Cloud):
```
administration/billing/index.md
```

使用（自托管版）：
```
administration/usage/index.md
```
使用与计费（云版）：
```
administration/billing/index.md
```

Concepts

核心概念

Learn about the core concepts in Materialize.

Namespaces:
```
concepts/namespaces/index.md
```
Clusters:
```
concepts/clusters/index.md
```
Indexes:
```
concepts/indexes/index.md
```
Reaction Time, Freshness, and Query Latency:
```
concepts/reaction-time/index.md
```
Sinks:
```
concepts/sinks/index.md
```
Sources:
```
concepts/sources/index.md
```
Views:
```
concepts/views/index.md
```

了解Materialize的核心概念。

命名空间：
```
concepts/namespaces/index.md
```
集群：
```
concepts/clusters/index.md
```
索引：
```
concepts/indexes/index.md
```
响应时间、数据新鲜度与查询延迟：
```
concepts/reaction-time/index.md
```
数据输出（Sink）：
```
concepts/sinks/index.md
```
数据源（Source）：
```
concepts/sources/index.md
```
视图：
```
concepts/views/index.md
```

Ingest data

数据摄入

Best practices for ingesting data into Materialize from external systems.

Amazon EventBridge:

ingest-data/webhooks/amazon-eventbridge/index.md

AWS PrivateLink connections (Cloud-only):

ingest-data/network-security/privatelink/index.md

CockroachDB CDC using Kafka and Changefeeds:
```
ingest-data/cdc-cockroachdb/index.md
```
Debezium:
```
ingest-data/debezium/index.md
```
Fivetran:
```
ingest-data/fivetran/index.md
```
HubSpot:
```
ingest-data/webhooks/hubspot/index.md
```
Kafka:
```
ingest-data/kafka/index.md
```
MongoDB:
```
ingest-data/mongodb/index.md
```

Monitoring data ingestion:

ingest-data/monitoring-data-ingestion/index.md

MySQL:
```
ingest-data/mysql/index.md
```
(and 12 more files in this section)

从外部系统向Materialize摄入数据的最佳实践。

Amazon EventBridge：

ingest-data/webhooks/amazon-eventbridge/index.md

AWS PrivateLink 连接（仅云版）：

ingest-data/network-security/privatelink/index.md

基于Kafka和Changefeeds的CockroachDB CDC：
```
ingest-data/cdc-cockroachdb/index.md
```
Debezium：
```
ingest-data/debezium/index.md
```
Fivetran：
```
ingest-data/fivetran/index.md
```
HubSpot：
```
ingest-data/webhooks/hubspot/index.md
```
Kafka：
```
ingest-data/kafka/index.md
```
MongoDB：
```
ingest-data/mongodb/index.md
```

数据摄入监控：

ingest-data/monitoring-data-ingestion/index.md

MySQL：
```
ingest-data/mysql/index.md
```
（本章节另有12个文件）

Manage Materialize

管理Materialize

Appendix: Alternative cluster architectures:

manage/appendix-alternative-cluster-architectures/index.md

Disaster recovery (Cloud):
```
manage/disaster-recovery/index.md
```
Monitoring and alerting:
```
manage/monitor/index.md
```
Operational guidelines:
```
manage/operational-guidelines/index.md
```
Use dbt to manage Materialize:
```
manage/dbt/index.md
```
Use Terraform to manage Materialize:
```
manage/terraform/index.md
```

附录：可选集群架构：

manage/appendix-alternative-cluster-architectures/index.md

灾难恢复（云版）：
```
manage/disaster-recovery/index.md
```
监控与告警：
```
manage/monitor/index.md
```
操作指南：
```
manage/operational-guidelines/index.md
```
使用dbt管理Materialize：
```
manage/dbt/index.md
```
使用Terraform管理Materialize：
```
manage/terraform/index.md
```

Materialize console

Materialize 控制台

Introduction to the Materialize Console, user interface for Materialize

Admin (Cloud-only):
```
console/admin/index.md
```
Clusters:
```
console/clusters/index.md
```
Connect (Cloud-only):
```
console/connect/index.md
```
Create new:
```
console/create-new/index.md
```
Database object explorer:
```
console/data/index.md
```
Integrations:
```
console/integrations/index.md
```
Monitoring:
```
console/monitoring/index.md
```
SQL Shell:
```
console/sql-shell/index.md
```
User profile:
```
console/user-profile/index.md
```

Materialize控制台介绍，即Materialize的用户界面

管理（仅云版）：
```
console/admin/index.md
```
集群：
```
console/clusters/index.md
```
连接（仅云版）：
```
console/connect/index.md
```
新建资源：
```
console/create-new/index.md
```
数据库对象浏览器：
```
console/data/index.md
```
集成：
```
console/integrations/index.md
```
监控：
```
console/monitoring/index.md
```
SQL Shell：
```
console/sql-shell/index.md
```
用户配置文件：
```
console/user-profile/index.md
```

Overview

概述

Learn how to efficiently transform data using Materialize SQL.

Dataflow troubleshooting:

transform-data/dataflow-troubleshooting/index.md

FAQ: Indexes:
```
transform-data/faq/index.md
```

Idiomatic Materialize SQL:

transform-data/idiomatic-materialize-sql/index.md

Optimization:
```
transform-data/optimization/index.md
```
Patterns:
```
transform-data/patterns/index.md
```
Troubleshooting:
```
transform-data/troubleshooting/index.md
```

Updating materialized views:

transform-data/updating-materialized-views/index.md

了解如何使用Materialize SQL高效转换数据。

数据流故障排查：

transform-data/dataflow-troubleshooting/index.md

常见问题：索引：
```
transform-data/faq/index.md
```

Materialize 惯用SQL写法：

transform-data/idiomatic-materialize-sql/index.md

优化：
```
transform-data/optimization/index.md
```
模式：
```
transform-data/patterns/index.md
```
故障排查：
```
transform-data/troubleshooting/index.md
```

更新物化视图：

transform-data/updating-materialized-views/index.md

Security

安全

Appendix:
```
security/appendix/index.md
```
Cloud:
```
security/cloud/index.md
```
Self-managed:
```
security/self-managed/index.md
```

附录：
```
security/appendix/index.md
```
云版：
```
security/cloud/index.md
```
自托管版：
```
security/self-managed/index.md
```

Self-Managed Deployments

自托管部署

Learn about the key components and architecture of self-managed Materialize deployments.

Appendix:

self-managed-deployments/appendix/index.md

Configuring System Parameters:

self-managed-deployments/configuration-system-parameters/index.md

Deployment guidelines:

self-managed-deployments/deployment-guidelines/index.md

FAQ:
```
self-managed-deployments/faq/index.md
```

Installation:

self-managed-deployments/installation/index.md

Materialize CRD Field Descriptions:

self-managed-deployments/materialize-crd-field-descriptions/index.md

Materialize Operator Configuration:

self-managed-deployments/operator-configuration/index.md

Self-managed release versions:

self-managed-deployments/release-versions/index.md

Troubleshooting:

self-managed-deployments/troubleshooting/index.md

Upgrading:

self-managed-deployments/upgrading/index.md

了解自托管Materialize部署的核心组件与架构。

附录：

self-managed-deployments/appendix/index.md

配置系统参数：

self-managed-deployments/configuration-system-parameters/index.md

部署指南：

self-managed-deployments/deployment-guidelines/index.md

常见问题：
```
self-managed-deployments/faq/index.md
```

安装：

self-managed-deployments/installation/index.md

Materialize CRD 字段说明：

self-managed-deployments/materialize-crd-field-descriptions/index.md

Materialize Operator 配置：

self-managed-deployments/operator-configuration/index.md

自托管版发布版本：

self-managed-deployments/release-versions/index.md

故障排查：

self-managed-deployments/troubleshooting/index.md

升级：

self-managed-deployments/upgrading/index.md

Serve results

结果输出

Serving results from Materialize

SELECT
and
SUBSCRIBE
:

serve-results/query-results/index.md

Sink results:
```
serve-results/sink/index.md
```
Use BI/data collaboration tools:
```
serve-results/bi-tools/index.md
```
Use foreign data wrapper (FDW):
```
serve-results/fdw/index.md
```

从Materialize输出结果

SELECT
与
SUBSCRIBE
：

serve-results/query-results/index.md

输出数据到Sink：
```
serve-results/sink/index.md
```
使用BI/数据协作工具：
```
serve-results/bi-tools/index.md
```
使用外部数据包装器（FDW）：
```
serve-results/fdw/index.md
```

SQL commands

SQL 命令

SQL commands reference.

Namespaces:
```
sql/namespaces/index.md
```
ALTER CLUSTER:
```
sql/alter-cluster/index.md
```
ALTER CLUSTER REPLICA:
```
sql/alter-cluster-replica/index.md
```
ALTER CONNECTION:
```
sql/alter-connection/index.md
```
ALTER DATABASE:
```
sql/alter-database/index.md
```
ALTER DEFAULT PRIVILEGES:
```
sql/alter-default-privileges/index.md
```
ALTER INDEX:
```
sql/alter-index/index.md
```
ALTER MATERIALIZED VIEW:
```
sql/alter-materialized-view/index.md
```
ALTER NETWORK POLICY (Cloud):
```
sql/alter-network-policy/index.md
```
ALTER ROLE:
```
sql/alter-role/index.md
```
(and 112 more files in this section)

SQL命令参考。

命名空间：
```
sql/namespaces/index.md
```
ALTER CLUSTER：
```
sql/alter-cluster/index.md
```
ALTER CLUSTER REPLICA：
```
sql/alter-cluster-replica/index.md
```
ALTER CONNECTION：
```
sql/alter-connection/index.md
```
ALTER DATABASE：
```
sql/alter-database/index.md
```
ALTER DEFAULT PRIVILEGES：
```
sql/alter-default-privileges/index.md
```
ALTER INDEX：
```
sql/alter-index/index.md
```
ALTER MATERIALIZED VIEW：
```
sql/alter-materialized-view/index.md
```
ALTER NETWORK POLICY（云版）：
```
sql/alter-network-policy/index.md
```
ALTER ROLE：
```
sql/alter-role/index.md
```
（本章节另有112个文件）

Tools and integrations

工具与集成

Get details about third-party tools and integrations supported by Materialize

Client libraries:
```
integrations/client-libraries/index.md
```
Connect to Materialize via HTTP:
```
integrations/http-api/index.md
```
Connect to Materialize via WebSocket:
```
integrations/websocket-api/index.md
```

Connection Pooling:

integrations/connection-pooling/index.md

**Foreign data wrapper (FDW) **:
```
integrations/fdw/index.md
```
MCP Server:
```
integrations/llm/index.md
```
mz - Materialize CLI:
```
integrations/cli/index.md
```
mz-debug:
```
integrations/mz-debug/index.md
```
SQL clients:
```
integrations/sql-clients/index.md
```

了解Materialize支持的第三方工具与集成详情

客户端库：
```
integrations/client-libraries/index.md
```
通过HTTP连接Materialize：
```
integrations/http-api/index.md
```
通过WebSocket连接Materialize：
```
integrations/websocket-api/index.md
```

连接池：

integrations/connection-pooling/index.md

外部数据包装器（FDW）：
```
integrations/fdw/index.md
```
MCP Server：
```
integrations/llm/index.md
```
mz - Materialize CLI：
```
integrations/cli/index.md
```
mz-debug：
```
integrations/mz-debug/index.md
```
SQL客户端：
```
integrations/sql-clients/index.md
```

Quick Reference

快速参考

Common SQL Commands

常用SQL命令

Command	Description
`CREATE SOURCE`	Connect to external data sources (Kafka, PostgreSQL, MySQL)
`CREATE MATERIALIZED VIEW`	Create incrementally maintained views
`CREATE INDEX`	Create indexes on views for faster queries
`CREATE SINK`	Export data to external systems
`SELECT`	Query data from sources, views, and tables

命令	描述
`CREATE SOURCE`	连接到外部数据源（Kafka、PostgreSQL、MySQL）
`CREATE MATERIALIZED VIEW`	创建增量维护的视图
`CREATE INDEX`	在视图上创建索引以加速查询
`CREATE SINK`	将数据导出到外部系统
`SELECT`	从数据源、视图和表中查询数据

Key Concepts

核心概念

Sources: Connections to external data systems that stream data into Materialize
Materialized Views: Views that are incrementally maintained as source data changes
Indexes: Arrangements of data in memory for fast point lookups
Clusters: Isolated compute resources for running dataflows
Sinks: Connections that export data from Materialize to external systems

数据源（Source）：连接到外部数据系统，将数据流摄入Materialize
物化视图：随数据源数据变化而增量维护的视图
索引：在内存中整理数据以实现快速点查询
集群：用于运行数据流的隔离计算资源
数据输出（Sink）：将Materialize中的数据导出到外部系统的连接