Forum Discussion
DATA SET SIZE
Hi all
I have the followin problem: "The size of one table is anormally huge"
Context:
- DB: redshift
- 1 Table
- 25 M records
- +12 Columns
- 800 Mb size
The problem is that one field (ID_KEY) its size is 400 Mb, just only one field and another field another 300 MB.
It is so weird because the field that size is 400 MB is "numero_expediente" (alpha numeric key) and for example there is other field "dsc_entidad" that its a free text field and his size is just only 20 MB.
I need to reduce the data set so... any idea?
2 Replies
Hi Anonymous
When importing data into Power BI, it would compress data using VertiPaq Engine.
Do you use the VertiPaq Analyzer to check the dataset size?
https://www.sqlbi.com/articles/data-model-size-with-vertipaq-analyzer/
If so, please go to Edit queries, "Transform->Format->clean/trim" for this column.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
