SPICE Capacity filled more that what the dataset weighs

Hello, I have a dataset that weighs 2.5 GBs in Redshift, but when I upload it to SPICE in QuickSight, the weight increases. For example, today the weight is 23 GB. How is this possible?

Thank you

The dataset size in SPICE will most of the times be different than it source since it depends on the data types. You will see this more notably when loading datasets like CSVs.

Hope this helps.

Kind regards,
Andres.

1 Like

Is there a way to work around it? I don’t want my SPICE capacity to be filling up so fast.

Thanks for your response!

Hello,

I am affraid this is not possible. The best options are to make sure you are using the right types for each data field, e.g. a string takes more space than an integer so make sure all your integers are defined as such.

Kind regards,
Andres.