This feature introduces a new manifest handler to read Delta table manifest files, which are text files that list the paths of the objects stored on external object store. The ability to read Delta tables using a foreign table or READ_NOS is enabled by this feature.
Benefits
- You can perform READ_NOS operations on a Delta table where the manifest files are generated.
Considerations
- This feature does not support WRITE_NOS.
- This feature reads the existing manifest file but does not generate a Manifest file for the given Delta table.
SQL Changes
- A new parameter, TABLE_FORMAT, is added to the CREATE FOREIGN TABLE and READ_NOS syntax.
Additional Information
For more information, see:
- Teradata Vantage™ - Native Object Store Getting Started Guide, B035-1214
- CREATE FOREIGN TABLE in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144
- READ_NOS in Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210 and Teradata Vantage™ - SQL Data Manipulation Language, B035-1146