Serve results

In Materialize, indexed views and materialized views maintain up-to-date query results. This allows Materialize to serve fresh query results with low latency.

To serve results, you can:

• Query using SELECT and SUBSCRIBE statements

• Use BI/data collaboration tools

• Sink results to to external systems

• Use Foreign Data Wrapper (FDW)

{{< multilinkbox >}} {{< linkbox title="SELECT/SUBSCRIBE statements" >}}

• Query using SELECT and SUBSCRIBE
• Use Foreign Data Wrapper (FDW) {{</ linkbox >}} {{< linkbox title="External BI tools" >}}
• Deepnote
• Excel
• Hex
• Metabase
• Power BI
• Tableau
• Looker {{</ linkbox >}}

{{< linkbox title="Sink results" >}}

• Sinking results to Amazon S3
• Sinking results to Census
• Sinking results to Kafka
• Sinking results to Snowflake {{</ linkbox >}}

{{</ multilinkbox >}}