Streams and dynamic tables

Streams can be created on dynamic tables, like streams on traditional tables, with the following limitations:

  • Refresh type: Streams can be created only on dynamic tables that refresh incrementally.

  • Stream type: Dynamic tables support only standard (i.e. delta) streams. For more information, see Types of Streams.

Create a stream on a dynamic table

The following example shows how to create a stream on a dynamic table:

-- Create the dynamic table, for reference only
CREATE OR REPLACE DYNAMIC TABLE product ...;

-- Create the stream.
CREATE OR REPLACE STREAM deltaStream ON DYNAMIC TABLE product;
Copy