delete_data_stream()#

relationalai.<rai_schema>
delete_data_stream(<source_table_name>)

Deletes a specified Change Data Capture (CDC) data stream within a specified RelationalAI (RAI) schema. The RAI schema retains a snapshot of the data stream’s contents at the time of deletion. Requires the cdc_admin or <rai_schema>_cdc application role.

Parameters#

NameTypeDescription
<source_table_name>STRINGThe fully qualified name of the source table or view in Snowflake.

Example#

Use delete_data_stream() to delete an existing CDC data stream within a specified RAI schema. Replace <source_table_name> with the fully qualified name of the source table or view.

For example, to delete a stream for the table my_table in the schema my_schema:

CALL relationalai.my_schema.delete_data_stream('my_db.my_schema.my_table');

See Also#