Skip to main content
A streaming job is a job that creates a materialized view, a table, a sink, or an index. When background DDL is enabled via SET BACKGROUND_DDL, these creation commands return immediately while the actual backfill runs in the background. The WAIT command lets you pause your session until a specific job — or all in-progress jobs — complete.

​
Syntax

WAIT [ TABLE table_name
     | MATERIALIZED VIEW mv_name
     | SINK sink_name
     | INDEX index_name ];
  • With no target, WAIT blocks until all background streaming jobs finish (timeout: 2 hours).
  • With a target, WAIT blocks until the specified object’s creation job finishes.

​
Parameters

ParameterDescription
TABLE table_nameWait for the background creation job of the specified user table.
MATERIALIZED VIEW mv_nameWait for the background creation job of the specified materialized view.
SINK sink_nameWait for the background creation job of the specified sink.
INDEX index_nameWait for the background creation job of the specified index.

​
Examples

Wait for all background jobs to finish: 
WAIT;
Start a materialized view creation in the background, then wait for it to complete before querying: 
SET BACKGROUND_DDL = true;

CREATE MATERIALIZED VIEW mv AS SELECT * FROM t;
-- Returns immediately; backfill runs in the background.

WAIT MATERIALIZED VIEW mv;
-- Blocks until the backfill for mv is done.

SELECT * FROM mv;
Wait for a specific table’s creation to finish: 
WAIT TABLE my_table;

SET BACKGROUND_DDL

SHOW JOBS

CANCEL JOBS