data_streams#
relationalai.<rai_schema>
#data_streams
Retrieves a VIEW
that lists all Change Data Capture (CDC) data streams within a specified RelationalAI (RAI) schema.
Provides information on each stream, including its name, source table or view, and status.
Requires the cdc_admin
or <rai_schema>_cdc
application role.
Example#
Use the data_streams
view to retrieve a list of all CDC data streams within a specified RAI schema:
#SELECT * FROM relationalai.my_schema.data_streams;