Sink results

A sink describes the external system you want Materialize to write data to and details the encoding of that data. You can sink data from a materialized view, a source, or a table.

Sink methods

To create a sink, you can:

Method	External system	Guide(s) or Example(s)
Use COPY TO command	Amazon S3 or S3-compatible storage	Sink to Amazon S3
Use Census as an intermediate step	Census supported destinations	Sink to Census
Use COPY TO S3 or S3-compatible storage as an intermediate step	Snowflake and other systems that can read from S3	Sink to Snowflake
Use a native connector	Kafka/Redpanda	Sink to Kafka/Redpanda
Use SUBSCRIBE	Various	Sink to Postgres Sink to Redis

Operational guideline

• Avoid putting sinks on the same cluster that hosts sources to allow for blue/green deployment.

Troubleshooting

For help, see Troubleshooting sinks.