Delta Lake

How e6data queries Delta Lake tables through external catalogs, what's supported, and how to connect.

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

Capability

Support

Deletion vectors

Supported

CHECK constraints

Supported

Change Data Feed (CDF)

Supported

Generated columns

Supported

Column mapping

Supported

Identity columns

Supported

Row tracking

Supported

Timestamp NTZ

Supported

Liquid clustering

Supported

Iceberg readers through UniForm

Supported

Type widening

Supported

VARIANT

Supported

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';