首页 项目目录 关于我们
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-sources.md

show-sources.md 1.7 KB
Permalink History Raw

title: "SHOW SOURCES" description: "SHOW SOURCES returns a list of all sources available in Materialize." menu: main:

parent: commands

SHOW SOURCES returns a list of all sources available in Materialize.

Syntax

SHOW SOURCES [ FROM <schema_name> ] [ IN CLUSTER <cluster_name> ]

Details

Output format for SHOW SOURCES

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

name  | type | cluster
------+------+--------
...   | ...  | ...
Option Description
FROM If specified, only show sources from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS.
IN CLUSTER If specified, only show sources from the specified cluster. For available clusters, see SHOW CLUSTERS.
Field Meaning
name The name of the source.
type The type of the source: kafka, postgres, load-generator, progress, or subsource.
cluster The cluster the source is associated with.

Examples

SHOW SOURCES;

            name    | type     | cluster
--------------------+----------+---------
 my_kafka_source    | kafka    | c1
 my_postgres_source | postgres | c2

SHOW SOURCES IN CLUSTER c2;

name               | type     | cluster
-------------------+----------+--------
my_postgres_source | postgres | c2

Related pages