cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
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.

Ajay Kumar Pandey

-werners-
Esteemed Contributor III

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