Materialize
/ Long-Term Support (LTS)
Back to Stable Docs ➟
Log In
Get Early Access
Materialize Documentation
s
Join the Community
github/materialize
Overview
What is Materialize?
Key concepts
Get started
Advanced concepts
Architecture overview
Arrangements
Volatility
Timelines
Materialize CDC
Quickstarts
Install Materialize
Build a real-time analytics dashboard
Run SQL on streaming logs
Replace a microservice with a SQL query
Reference
Sources
Kafka
Redpanda
PostgreSQL
S3
Kinesis Data Streams
Local files
Tables
Views
Materialized views
Joins
Indexes
Sinks
Queries (
SELECT
)
Subscriptions (
TAIL
)
SQL patterns
Temporal filters (sliding, hopping, tumbling windows)
Time-To-Live
Top K by group
SQL commands
ALTER … RENAME
ALTER INDEX
BEGIN
CLOSE
COMMIT
COPY FROM
COPY TO
CREATE DATABASE
CREATE INDEX
CREATE MATERIALIZED VIEW
CREATE ROLE
CREATE SCHEMA
CREATE SINK
CREATE SOURCE
CREATE TABLE
CREATE TYPE
CREATE USER
CREATE VIEW
CREATE VIEWS
DEALLOCATE
DECLARE
DELETE
DISCARD
DROP DATABASE
DROP INDEX
DROP ROLE
DROP SCHEMA
DROP SINK
DROP SOURCE
DROP TABLE
DROP TYPE
DROP USER
DROP VIEW
EXECUTE
EXPLAIN
FETCH
INSERT
PREPARE
ROLLBACK
SELECT
SHOW COLUMNS
SHOW CREATE INDEX
SHOW CREATE SINK
SHOW CREATE SOURCE
SHOW CREATE TABLE
SHOW CREATE VIEW
SHOW DATABASES
SHOW INDEX
SHOW OBJECTS
SHOW SCHEMAS
SHOW SINKS
SHOW SOURCES
SHOW TABLES
SHOW TYPES
SHOW VIEWS
TAIL
UPDATE
SQL functions & operators
Aggregate function filters
array_agg function
CAST function and operator
COALESCE function
csv_extract function
date_bin function
date_bin_hopping 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_logical_timestamp 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
numeric type
oid type
record type
text type
time type
Timestamp types
uuid type
SQL identifiers
SQL namespaces
System catalog
materialized
binary
Operating Materialize
Monitoring
Optimization
Troubleshooting
Tools and integrations
Overview
SQL clients
dbt
Client libraries
Go
Java
Node.js
PHP
Python
Ruby
Integration guides
Redpanda
Redpanda Cloud
PostgreSQL
MySQL
Debezium
AWS Aurora
AWS MSK
AWS RDS PostgreSQL
Azure DB for PostgreSQL
DigitalOcean PostgreSQL
GCP Cloud SQL
Metabase
About
Release notes
Versions
Support
License
Security overview
Responsible disclosure policy
Operating Materialize
Monitoring
Optimization
Troubleshooting