CREATE SOURCE
CREATE SOURCE connects Materialize to some data source, and lets you interact
with its data as if it were in a SQL table.
Conceptual framework
Sources represent connections to resources outside Materialize that it can read data from. For more information, see Key Concepts: Sources.
Types of sources
Materialize can connect to many different external sources of data, each with their own requirements. For details about creating sources, view the documentation for the type of data you are trying to load into Materialize:
| Source type | Avro | Text/bytes | Protobuf | CSV | JSON |
|---|---|---|---|---|---|
| Kafka | Avro + Kafka | Text/bytes + Kafka | Protobuf + Kafka | CSV + Kafka | JSON + Kafka |
| Kinesis | - | Text/bytes + Kinesis | Protobuf + Kinesis | CSV + Kinesis | JSON + Kinesis |
| S3 | - | Text/bytes + S3 | - | CSV + S3 | JSON + S3 |
| PubNub | - | Text + PubNub | - | - | JSON + PubNub |
| Local files | Avro + file | Text/bytes + file | - | CSV + files | JSON + file |
| Postgres | - | - | - | - | - |
Don’t see what you’re looking for? Let us know on GitHub.