How do you keep a plain Delta copy of a streaming table? CLONE is not supported on streaming tables

binlogreader
New Contributor

Hi All, 

I need an up-to-date plain Delta copy of a streaming table created by Lakeflow pipeline. 

My first thought was CLONE, and that path is closed. The clone docs say streaming tables and materialized views cannot be the source or target of a deep or shallow clone, and testing confirms it:

```
[STREAMING_TABLE_OPERATION_NOT_ALLOWED.UNSUPPORTED_OPERATION]
The operation DEEP CLONE is not allowed: The operation is not supported on Streaming Tables.
```

My questions:

1. Is there a supported mechanism I'm missing that produces an incremental (or even full), file-level copy of a streaming table, the way deep clone does for plain Delta tables?
2. If CDF plus MERGE is the intended pattern for this, is there guidance on doing it safely against a table that a pipeline owns (full refresh on the source, for example, changes the version history the copy job depends on)?
3. Is the clone limitation on streaming tables permanent by design, because the pipeline owns the table's files, or is it a current-state gap?