Learn about connecting to data sources and ingesting data into RisingWave.
CREATE TABLE
statement without a WITH
clause. You populate these tables manually (for example, using INSERT
statements).
CREATE TABLE ... WITH (connector=...)
statement. These tables are automatically and continuously populated by ingesting data from an external source.
CREATE SOURCE
(data not stored):
CREATE SOURCE
CREATE TABLE ... WITH (connector=...)
(data stored, continuous ingestion):
CREATE TABLE
CREATE SOURCE
for temporary connections, quick exploration, or to build streaming pipelines with materialized views and/or sinks. Use CREATE TABLE ... WITH (connector=...)
for continuous ingestion when you need to store the full raw data for historical analysis or other benefits.
CREATE SOURCE
or CREATE TABLE ... WITH (connector=...)
.CREATE SINK
to deliver processed data to external systems. Sinks are also streaming jobs that continuously send data to their destination. Applications can also connect directly to RisingWave and query the results of materialized views or tables without a sink.CREATE SOURCE
and then manually copy data into a standard (batch) table using INSERT INTO ... SELECT
:
CREATE SOURCE
and CREATE TABLE
.