topic Re: Data Warehouse in Databricks Date values as date or int: what is recommended? in Warehousing & Analytics

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

DataFarmer — Thu, 11 Apr 2024 09:29:50 GMT

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?

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

Ajay-Pandey — Tue, 23 Apr 2024 12:39:56 GMT

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.

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

-werners- — Wed, 24 Apr 2024 07:49:20 GMT

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