resume_cdc()#
#resume_cdc()
Enable or resume ingestion of Change Data Capture (CDC) into the RelationalAI (RAI) Native App.
Requires the cdc_admin
application role.
Example#
Use resume_cdc()
to enable CDC for the RAI Native App after installing it or to resume CDC after suspending it:
#CALL relationalai.app.resume_cdc();
Resuming CDC provisions a new CDC engine named CDC_MANAGED_ENGINE
with size HIGHMEM_X64_S
that is used to process CDC data.
Note that this engine is not created immediately, but is provisioned on-demand once changes are detected in source tables and views.
You can alter the size of the CDC engine using the alter_cdc_engine_size()
procedure.
Any changes tracked while the service was suspended are ingested as soon the service is resumed. New changes to the source tables and views are tracked and ingested as usual.