Persistent View Where Sql
A SQL clause added to the persistent views that read from the Persistent Staging Area (PSA), used to filter the rows those views return.
The value is placed on its own line directly after the FROM clause of each generated persistent view, so it holds the whole clause, including the WHERE keyword. A blank value adds no clause. The views themselves are generated only when Create Persistent View is enabled.
In the view, the PSA table carries the alias STG, or the source object's Object Alias override when one is set. Column references written with the STG. or SRC. prefix are rewritten to that alias, so the same clause works with or without an override. The quoted form "STG"."Column" is not rewritten, so objects with an Object Alias override need the unquoted STG. prefix.
When to Change This Setting
Set it when the persistent views should return only a subset of the rows in the PSA table. Keep it blank for views over the full PSA table.
Related Settings
| Setting | Interaction |
|---|---|
| Create Persistent View | Enables the persistent views this clause is added to |
| Prefix Persistent View | The prefix used in the view names |
| Row Hash Persistent View | Controls whether the views expose the row hash |
Notes
- This setting is part of the Staging settings category.