Materialize
Docs
Product
Solutions
Pricing
Company
Log In
Register for Cloud
Materialize Documentation
s
Join the Community
github/materialize
Overview
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
Postgres
S3
Kinesis
Local Files
PubNub
Tables
Views
Materialized Views
Joins
Indexes
Sinks
Queries (
SELECT
)
Subscriptions (
TAIL
)
SQL Patterns
Temporal Filters (Sliding, Hopping, Tumbling Windows)
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 Data Types
boolean Data Type
bytea Data Type
date Data Type
Floating-Point Data Types
Integer Data Types
interval Data Type
jsonb Data Type
List Data Types
map Data Type
numeric Data Type
oid Data Type
record Data Type
text Data Type
time Data Type
Timestamp Data Types
uuid Data Type
SQL Identifiers
SQL Namespaces
System Catalog
materialized
Binary
Materialize Cloud
Get Started with Cloud
Connect to Cloud
Account Limits
Cloud Deployments
Maintenance Windows
Manage a Workspace
Manage Users
Monitor Cloud
Security
Settings
Troubleshoot Cloud
Operating Materialize
Monitoring
Optimization
Troubleshooting
Tools and Integrations
Overview
SQL clients
dbt
Client Libraries
Go
Java
Node.js
PHP
Python
Ruby
Integration Guides
Redpanda Kafka
PostgreSQL
MySQL
Debezium
AWS Aurora
AWS MSK
AWS RDS PostgreSQL
Azure DB for PostgreSQL
DigitalOcean PostgreSQL
Docker
GCP Cloud SQL
Metabase BI
About
Release Notes
Versions
Support
License
Security Overview
Responsible Disclosure Policy
Quickstarts
Build a Real-time Analytics Dashboard
Run SQL on Streaming Logs
Replace a Microservice with a SQL Query
Build Live Views for Reverse ETL
Did this info help?
Yes
No