The S3 data lake feature uses Parquet format and normalised tables. We need a way to reduce the data scanned in queries when filtering by dates.
So if there was an option to partition data by Year, Month, Day then we could reduce the data scanned 1000x.
I would expect this to be preconfigured when selecting the Schema in a connector. It would define the partitions for default properties such as Dates.