naming approach for hierarchy

Hi SamyAbdul​,

I would keep the explicit Hive-style naming if you are actually partitioning the Delta table.

Microsoft documents the standard pattern as:

Source/
year=2026/
month=09/
day=26/

rather than:

Source/
2026/
09/
26/

The reason is that year, month and day become explicit partition columns rather than just folder names.

That allows query engines to understand the partition structure and perform partition pruning when filters use those columns.

Microsoft documents this pattern in the Delta table partitioning guidance.

For example, if you create the table with:

PARTITIONED BY (Year, Month, Day)

Fabric/Delta will generate the corresponding Hive-style folder layout automatically.

I would therefore avoid manually creating numeric-only folders for managed Delta tables.

One other point: I would not automatically partition every dataset down to day level.

Microsoft recommends avoiding too many small partitions and suggests targeting roughly 1 GB or more per partition.

So depending on data volume, something like:

year + month

may be better than:

year + month + day

For most Fabric Runtime 2.0 workloads, Microsoft also now recommends liquid clustering for general read-performance optimization, while traditional partitioning is especially useful when you need isolated concurrent writes.

So my rule would be:

Delta table
-> define meaningful partition columns

physical folders
-> let Delta/Fabric create them

naming
-> use year=2026/month=09/day=26 rather than anonymous 2026/09/26

AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.