StreamNative does not automatically purge SQLWorkspace engine data when you delete a SQLWorkspace or SQLCatalog. The retained data and runtime behavior depend on which resource you delete.
SQLWorkspace data
Deleting a SQLWorkspace removes its managed SQL runtime and makes its query endpoints unavailable. By default, StreamNative retains both of the following:
- Engine metadata in the metadata store, including SQL object definitions and runtime metadata.
- Durable streaming state and processed data in object storage.
The SQLWorkspace deletion does not automatically purge either storage location. It also does not delete connected Pulsar or Kafka clusters or their topics.
Retained data is not queryable after the SQLWorkspace runtime is deleted.
SQLCatalog data
Deleting a SQLCatalog stops topic discovery and stops its managed sources from consuming newly published records. StreamNative retains data that the SQLWorkspace engine already ingested or processed.
The SQLCatalog deletion does not delete the source Pulsar or Kafka cluster, its topics, or the records stored in those topics. 
