> ## Documentation Index
> Fetch the complete documentation index at: https://docs.streamnative.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Retention

> Understand what happens to SQLWorkspace and SQLCatalog data when you delete a resource.

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](/sql/overview/engine/metadata-store), including SQL object definitions and runtime metadata.
* Durable streaming state and processed data in [object storage](/sql/overview/engine/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.

<Note>
  Retained data is not queryable after the SQLWorkspace runtime is deleted.
</Note>

## 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.