my own answer after couple years working in the field

Delta Lake on Databricks does not natively support primary keys or unique constraints like traditional relational databases. The "index" mentioned in Delta Lake's features is primarily about internal optimizations for performance, such as data skipping and Z-ordering.

You can enforce uniqueness with deduplication, upserts, and custom checks. For performance, leverage data skipping, Z-ordering, and partitioning.