Documentation
Docs
Pricing
Blog
About
Login
Get Early Access
Docs
Pricing
Blog
About
Login
Get Early Access
Overview
What is Materialize?
Key concepts
Advanced concepts
Arrangements
Consistency guarantees
Quickstarts
Get started with Materialize
Reference
Clusters
Connections
Sources
Kafka
Redpanda
PostgreSQL
Load generator
Sinks
Kafka
Redpanda
Views
Materialized views
Indexes
Joins
Queries (
SELECT
)
Subscriptions (
SUBSCRIBE
)
SQL patterns
Percentile calculation
Temporal filters (sliding, hopping & tumbling windows)
Time-To-Live
Top K by group
Window functions (OVER clause)
SQL commands
ALTER … RENAME
ALTER CONNECTION
ALTER INDEX
ALTER SECRET
ALTER SINK
ALTER SOURCE
BEGIN
CLOSE
COMMIT
COPY FROM
COPY TO
CREATE CLUSTER
CREATE CLUSTER REPLICA
CREATE CONNECTION
CREATE DATABASE
CREATE INDEX
CREATE MATERIALIZED VIEW
CREATE ROLE
CREATE SCHEMA
CREATE SECRET
CREATE SOURCE
CREATE TABLE
CREATE TYPE
CREATE USER
CREATE VIEW
DEALLOCATE
DECLARE
DELETE
DISCARD
DROP CLUSTER
DROP CLUSTER REPLICA
DROP CONNECTION
DROP DATABASE
DROP INDEX
DROP MATERIALIZED VIEW
DROP ROLE
DROP SCHEMA
DROP SECRET
DROP SINK
DROP SOURCE
DROP TABLE
DROP TYPE
DROP USER
DROP VIEW
EXECUTE
EXPLAIN
FETCH
INSERT
PREPARE
ROLLBACK
SELECT
SHOW CLUSTER REPLICAS
SHOW CLUSTERS
SHOW COLUMNS
SHOW CONNECTIONS
SHOW CREATE CONNECTION
SHOW CREATE INDEX
SHOW CREATE MATERIALIZED VIEW
SHOW CREATE SINK
SHOW CREATE SOURCE
SHOW CREATE TABLE
SHOW CREATE VIEW
SHOW DATABASES
SHOW INDEXES
SHOW MATERIALIZED VIEWS
SHOW OBJECTS
SHOW SCHEMAS
SHOW SECRETS
SHOW SINKS
SHOW SOURCES
SHOW TABLES
SHOW TYPES
SHOW VIEWS
SUBSCRIBE
UPDATE
SQL functions & operators
Aggregate function filters
array_agg function
CAST function and operator
COALESCE function
csv_extract function
date_bin function
date_part function
date_trunc function
encode and decode functions
EXTRACT function
jsonb_agg function
jsonb_object_agg function
justify_days function
justify_hours function
justify_interval function
LENGTH function
list_agg function
now and mz_now functions
string_agg function
SUBSTRING function
TIMEZONE and AT TIME ZONE functions
to_char function
SQL data types
Array types
boolean type
bytea type
date type
Floating-point types
Integer types
interval type
jsonb type
List types
map type
mz_timestamp type
numeric type
oid type
record type
text type
time type
Timestamp types
Unsigned Integer types
uuid type
SQL identifiers
SQL namespaces
System catalog
mz_catalog
pg_catalog
information_schema
mz_internal
Operating Materialize
Network security
Static IP addresses
AWS PrivateLink connections
SSH tunnel connections
Optimization
Troubleshooting
Tools and integrations
Overview
SQL clients
HTTP API
WebSocket API
dbt
Client libraries
Go
Java
Node.js
PHP
Python
Ruby
Integration guides
Redpanda
Redpanda Cloud
Confluent Cloud
Upstash Kafka
PostgreSQL CDC
MySQL CDC
Debezium
Amazon MSK
Metabase
About
Releases
Support
License
Security overview
Responsible disclosure policy
Close
Arrow Pointing to the left
All Topics
Operating Materialize
AWS PrivateLink connections
Optimization
SSH tunnel connections
Static IP addresses
Troubleshooting
Back to top ↑