Delta Lake - e6data Docs

e6data supports querying Delta Lake tables through external catalogs such as AWS Glue, Hive Metastore, Microsoft Fabric, and Unity Catalog.

Capability	Support	Description
Deletion vectors	Supported	Marks deleted or updated rows without immediately rewriting the underlying Parquet files.
CHECK constraints	Supported	Enforces defined conditions on table data and rejects invalid writes.
Change Data Feed (CDF)	Supported	Captures row-level inserts, updates, and deletes between table versions.
Generated columns	Supported	Automatically calculates column values using expressions based on other columns.
Column mapping	Supported	Allows columns to be renamed or dropped without rewriting existing data files.
Identity columns	Supported	Automatically generates sequential numeric values for inserted rows.
Row tracking	Supported	Assigns stable row identifiers and tracks when each row was last modified.
Timestamp NTZ	Supported	Stores timestamp values without timezone information or timezone conversion.
Liquid clustering	Supported	Organizes data using clustering columns that can evolve as access patterns change.
Iceberg readers through UniForm	Supported	Generates Iceberg-compatible metadata so compatible Iceberg engines can read the Delta table.
Type widening	Supported	Allows compatible changes to wider data types without rewriting existing data files.
`VARIANT`	Supported	Stores and queries semi-structured data such as JSON objects, arrays, and scalar values.

Sample queries

-- List all tables in a namespace
SHOW TABLES FROM delta_catalog.analytics;

-- Query from a Delta table
SELECT *
FROM delta_catalog.analytics.user_activity
WHERE event_type = 'purchase';

See also

Last modified on October 1, 2026