Skip to main content
StreamNative does not automatically purge SQL Workspace engine data when you delete a SQL Workspace or SQL Catalog. The retained data and runtime behavior depend on which resource you delete.

​
SQL Workspace data

Deleting a SQL Workspace removes its managed SQL runtime and makes its query endpoints unavailable. By default, StreamNative retains:
  • SQL object definitions and other workspace metadata.
  • Durable stream-processing state and processed data.
The SQL Workspace deletion does not automatically purge this data. It also does not delete connected Pulsar or Kafka clusters or their topics.
Retained data is not queryable after the SQL Workspace runtime is deleted.

​
SQL Catalog data

Deleting a SQL Catalog stops topic discovery and stops its managed sources from consuming newly published records. StreamNative retains data that the SQL Workspace engine already ingested or processed. The SQL Catalog deletion does not delete the source Pulsar or Kafka cluster, its topics, or the records stored in those topics.