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#
| Name | Type | Description |
|---|---|---|
<source_table_name> | STRING | The 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');