Difference in Table size between snowflake db and QuickSight Spice

Hello Everyone,

I have a question regarding the difference between the snowflake database size and QuickSight Spice size.

For instance, when I see the table size in Snowflake it is showing just 5.7 GB as below:
Screen Shot 2022-11-03 at 11.42.23

But when I load the same data on QuickSight on spice it is showing 203.6 GB as below:

Why it is showing the huge difference between Snowflake Database and QuickSight Spice Size. Your help is highly appreciated.

Hi @Santosh, you can see how SPICE capacity is calculated here. The size will depend on the datatypes you’re importing, but also includes any calculated fields that you’re defining in your data preparation stage. Also, SPICE is designed to enhance query performance and so will not directly reflect the same storage mechanism as your source.

Have a look at the doc and see if that makes sense. If you think the size is still excessive I would recommend you open a support ticket.

Thank you so much for your answer. It was really helpful.

1 Like