# Patterns

Learn about common Materialize export patterns.




> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


The following section provides examples of implementing some common export
patterns in Materialize:


## Pages in this section

- [Build SCD Type 2 history from an Iceberg sink](https://preview.materialize.com/materialize/40269/markdown-docs/export-data/patterns/scd-type-2-iceberg/index.md): Derive a Slowly Changing Dimension (SCD) Type 2 history, with a validity interval for every version of every row, from an Iceberg sink in append mode.
- [Transactional downstream updates using Kafka](https://preview.materialize.com/materialize/40269/markdown-docs/export-data/patterns/transactional-downstream-updates-kafka/index.md): Expose only fully committed Materialize timestamps when loading a Kafka sink into another data store.