cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

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

DataFarmer
New Contributor II

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?

2 REPLIES 2

Ajay-Pandey
Esteemed Contributor III

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-
Esteemed Contributor III

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