Data Warehouse in Databricks Date values as date or int: what is recommended?

[DataFarmer]

In  relational data warehouse systems it was best practise to represent date values as YYYYMMDD integer type values in tables. Date comparison could be done easily without using date-functions and with low performance impact.

Is this still the recommended way in a delta lakehouse architecture?

[Ajay-Pandey]

Hi @DataFarmer 

I Databricks I will advise you to use date type instead of int, this will make your life much simpler while working on the date type data.

[-werners-]

Definitely +1.
You don't want to lose leading zeroes f.e.