Back to Materialize

Database object explorer

doc/user/content/console/data.md

1232.8 KB
Original Source

Under Data, the Materialize Console provides a database object explorer.

<span class="caption"> When you select <em>Data</em>, the left panel collapses to reveal the database object explorer. </span>

You can inspect the objects in your databases by navigating to the object.

ObjectAvailable information
Connections<li>Details: The CREATE CONNECTION SQL statement.</li>
Indexes<li>Details: The CREATE INDEX SQL statement.</li><li>Workflow: Details about the index (e.g., status), freshness, upstream and downstream objects. </li><li>Visualize: Dataflow visualization.</li>
Materialized Views<li>Details: The CREATE MATERIALIZED VIEW SQL statement.</li><li>Workflow: Details about the materialized view (e.g., status), freshness, upstream and downstream objects.</li><li>Visualize: Dataflow visualization.</li>
Sinks<li>Overview: View the sink metrics (e.g., messages/bytes produced) and details (e.g., Kafka topic).</li><li>Details: The CREATE SINK SQL statement.</li><li>Errors: Errors associated with the sink.</li><li>Workflow: Details about the sink (e.g., status), freshness, upstream and downstream objects.</li>
Sources<li>Overview: View the ingestion metrics (e.g., Ingestion lag, messages/bytes received, Ingestion rate), Memory/CPU/Disk usage</li><li>Details: The CREATE SOURCE SQL statement.</li><li>Errors: Errors associated with the source.</li><li>Subsources: List of associated subsources and their status.</li><li>Workflow: Details about the source (e.g.,status), freshness, upstream and downstream objects.</li><li>Indexes: Indexes on the source.</li>
Subsources<li>Details: The CREATE SUBSOURCE SQL statement.</li><li>Columns: Column details.</li><li>Workflow: Details about the subsource (e.g.,status), freshness, upstream and downstream objects.</li><li>Indexes: Indexes on the subsource.</li>
Tables<li>Details: The CREATE TABLE SQL statement.</li><li>Workflow: Details about the table (e.g., status), freshness, upstream and downstream objects.</li><li>Columns: Column details.</li><li>Indexes: Indexes on the table.</li>
Views<li>Details: The CREATE VIEW SQL statement.</li><li>Columns: Column details.</li><li>Indexes: Indexes on the view. </li>

Sample source overview

Sample index workflow