首页 项目目录 关于我们
Sign In
rust
/
Materialize
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Materialize
/
doc
/
user
/
content
/
sql
/
show-subsources.md

show-subsources.md 1.9 KB
Permalink History Raw

title: "SHOW SUBSOURCES" description: "SHOW SUBSOURCES returns the subsources in the current schema." menu: main:

parent: commands

SHOW SUBSOURCES returns the subsources in the current schema.

Syntax

SHOW SUBSOURCES [ FROM <schema_name> | ON <source_name> ]

Details

A subsource is a relation associated with a source. There are two types of subsources:

  • Subsources of type progress describe Materialize's ingestion progress for the parent source. Every source has exactly one subsource of type progress.

  • Subsources of type subsource are used by sources that need to ingest data into multiple tables, like PostgreSQL sources. For each upstream table that is selected for ingestion, Materialize creates a subsource of type subsource.

Output format for SHOW SUBSOURCES

SHOW SUBSOURCES's output is a table, with this structure:

 name  | type
-------+-----
 ...   | ...
Option Description
FROM If specified, only show subsources from the specified schema. Defaults to first resolvable schema in the search path.
ON If specified, only show subsources on the specified source.
Field Meaning
name The name of the subsource.
type The type of the subsource: subsource or progress.

Examples

SHOW SOURCES;

    name
----------
 postgres
 kafka

SHOW SUBSOURCES ON pg;

        name        | type
--------------------+-----------
 postgres_progress  | progress
 table1_in_postgres | subsource
 table2_in_postgres | subsource

SHOW SUBSOURCES ON kafka;

            name    | typef
--------------------+----------
 kafka_progress     | progress

Related pages