Payload Filtering - Teradata VantageCloud Lake
Lake - Manage and Move Data
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata VantageCloud Lake
- Release Number
- Published
- February 2025
- ft:locale
- en-US
- ft:lastEdition
- 2025-05-16
- dita:mapPath
- atx1683670417382.ditamap
- dita:ditavalPath
- pny1626732985837.ditaval
- dita:id
- atx1683670417382
- The payload column within a foreign table contains all of the values within an object.
- In payload filtering you apply a filter to the data itself and not to the partitioning (path key) of the external object storage.
- When filtering is applied to a column in the data (such as WHERE Flow > '15'), all objects in the external object storage have to be brought inside the database and be transformed prior to applying filtering.
- When given a choice, this is typically less efficient because it incurs greater effort at both the external object storage level and the database level than does path filtering.