Forum Discussion
Fixed length decimal data type in Databricks
Good Day Forum I am in the process of moving our Power BI reporting data sources from Azure Synapse to Azure Dtabricks. Our models are composite model meaning we have direct query and and in-memory...
Hey MattKarriker2 ,
I’m not very familiar with Databricks, so I can’t help much with that. However, are you sure that using the currency data type reduces memory footprint? I recall reading articles on SQLBI stating that currency and decimal both use 8 bytes.
Here I found the article https://www.sqlbi.com/articles/choosing-numeric-data-types-in-dax/
Have you tested the performance without converting the numbers?
EDIT: Oh, I just noticed this thread is from 2023, never mind! 😅