Forum Discussion
fredforest
2 years agoNew Member
Data types in Delta
In the olden days of data warehousing, a developper/modeler would be careful to optimize data types (especially on large fact tables) for a variety of reasons. I'm wondering if there's still a reaso...
- 2 years ago
Well, I did offer some advice as to why we still want to optimise data types. The engine will provide the resources necesarry to process data operations based on data types and precision. The bigger the data type and precision, the bigger the resources are used to process. If you keep your data type sizes to a minimum, this will help the engine only provision what it needs.
Also, if we define our tables with data type sizes in Delta, it will stick to the data type size (e.g. cannot declare a string as 100 and then insert 200 chars in)
v-cboorla-msft
Microsoft Employee
2 years agoHi fredforest
Glad that your query got resolved.
Please continue using Fabric Community for any help regarding your queries.